SQLTeam.com | Weblogs | Forums

Find the filed in cloumn

tsql
sql2014

#1

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
V1;UPD;;;;;;;;;201204250530;201204251130;LGW;LGW;SBF;IT;;;;;;;;;;;;;;;
im using this funcation in orcale
REGEXP_SUBSTR( EA.ACTIVITYINFO, '([^;]*)(;|$)', 1, 13, NULL, 1 )


#2

anyone


#3

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


#4

Are you asking to reproduce this functionality in SQL Server?


#5

yes Jotorre


#6

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.