Browse by Tags

• string
• tsql

How to get a text from comma seperated string?
17 July 07 02:35 AM | SQL Master | 1 Comments   

create FUNCTION dbo.GetStringFromPosition(@DataList nvarchar(400),@Position integer) RETURNS nvarchar(100) AS BEGIN IF Len(@DataList)=0 RETURN '' DECLARE @Ptr int, @Length int, @Value int,@StartLocation int; Declare @RetString nvarchar(100); SET @Ptr Read More...

Filed under: tsql, sql server, string, charindex, comma