SELECT 'ls'+cast(LEN(Customername ) - LEN(REPLACE(Customername , 'l', '')) as varchar(50)) from Customer WHERE (Customername = 'SunilSunilAnil')
SELECT 'A''s' + CONVERT( varchar(100), (SELECT COUNT(*) FROM TableName WHERE ColumnName = 'A')) ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)