| Author: venu kumar 30 May 2008 | Member Level: Silver | Rating:  Points: 2 |
i dont think we can write a query for that instead we can write a stored procedure
|
| Author: @@@ Hyderabadi Biryani @@@ 31 May 2008 | Member Level: Diamond | Rating: Points: 1 |
SELECT LENGTH('VIJAY') - length(REPLACE('VIJAY','A')) AS No_Of_A_Characters
FROM DUAL
This is in oracle but you can write similar query in SQL Server.
Thanks -- Vj
|
| Author: Mohammad Faisal 01 Jun 2008 | Member Level: Bronze | Rating: Points: 2 |
But this code is not working in SQL Server 2005.
|