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.