Burman@cool blog's(ASP.NET,SQL SERVER,JavaScript,XML,sharepoint,WCF,SSIS)
Thursday, December 12, 2013
how to get first value in string using sql substring function
SUBSTRING(transaction_claimant_Firstname,1,(CHARINDEX('|',transaction_claimant_Firstname + '|')-1))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment