How to find the no of occurance of a character in a string using SSIS
Hi,
I have a data like "AAAA,BBBB,CCCC,DDDDD". I want to find the no of occurance of the ",".
Please suggest me some one how to do this.Kanth
itdiligent
November 23rd, 2010 3:38am
DECLARE
@st VARCHAR(50)
SET
@st='AAAA,BBBB,CCCC,DDDDD'
SELECT
LEN(@st)-LEN(REPLACE(@st,',',''))Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 3:50am