I am in the process of improving my stored procedures.
So,in one of the stored procedure,'like' operator is used ,now i want to replace this like operator.in order to replace like operator i used patindex as shown below:
where columnname like '%'
replaced it as:
when i replaced as shown above,it was not working well.i got an error saying"expects a boolean expression"
can someone help me with this?
View Complete Post