Tuesday, July 28, 2015

"Like" on float datatype needs to have casting in sql server query

Below is the query :-

(Cast(Cast({0} as decimal) as NVARCHAR(250)) LIKE '%{1}%'),val1,val2)


here val 1 is the name of the column ,val 2 is the value of the column on which we need to perform like operation.

No comments:

Post a Comment