Monday, 13 February 2012

how to replace spaces and compare where condition

Declare @Credential varchar(500)
SET @Credential = 'MediCAl  Doctor'
 select Credentials_Id from PMP_Credentials where REPLACE(Description,' ','')= REPLACE(@Credential,' ','') 

No comments:

Post a Comment