Friday, August 8, 2008

Split string as Array in SQL

Hi,



i was in need to split string in T-sql but i can't find built-in function to do that, thereby i wrote a function to do the following:



By the use of T-SQL:



if you have string like "Ahmed,Eid,Salim" or Ids like "120,234,123,546"

and you need deal with that string as array on SQL DB Engine and find items of it.





The SQL Function like:

0 comments:

ANTIQR26
By: Favoshots
Views: 0
ANTIQR27
By: Favoshots
Views: 0
ANTIQR29
By: Favoshots
Views: 0
ANTIQR31
By: Favoshots
Views: 0
ANTIQR32
By: Favoshots
Views: 0
ANTIQR33
By: Favoshots
Views: 0
ANTIQR34
By: Favoshots
Views: 0
ANTIQR37
By: Favoshots
Views: 1
ANTIQR38
By: Favoshots
Views: 1
ANTIQR40
By: Favoshots
Views: 1
ANTIQR41
By: Favoshots
Views: 1
ANTIQRA
By: Favoshots
Views: 1
ANTIQRA2
By: Favoshots
Views: 1
ANTIQRA3
By: Favoshots
Views: 1
ANTIQRA4
By: Favoshots
Views: 1
ANTIQRA5
By: Favoshots
Views: 1