how to check like condition in if loop

54 Views Asked by At

I need to validate a string variable contains a string validation like below. how to do it in sybase ase?

if @text like '%test%' 
begin
end

i tried with this statement and i get Function LIKE is invoked with wrong number of arguments. as i am new to sybase not sure its proper syntax.

Updated the actual code and error print.

enter image description here

and the version says as 'Adaptive Server Enterprise/16.0 SP03 ....'

0

There are 0 best solutions below