Find the filed in cloumn

,
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 regex - Replace REGEXP_SUBSTR in SQL Server - Stack Overflow
Remember Bing and Google are your friends.