SQLTeam.com | Weblogs | Forums

Find the filed in cloumn



is there any way to find the field from this kind of records in SQL ... i want to find for xample SBF, and 1st LGW from this
im using this funcation in orcale
REGEXP_SUBSTR( EA.ACTIVITYINFO, '([^;]*)(;|$)', 1, 13, NULL, 1 )




This is a SQL Server database forum. No doubt you would get better responses on an Oracle forum.


Are you asking to reproduce this functionality in SQL Server?


yes Jotorre


I don't know if this is what you're looking for but hth http://stackoverflow.com/questions/36189734/replace-regexp-substr-in-sql-server
Remember Bing and Google are your friends.