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.
and the version says as 'Adaptive Server Enterprise/16.0 SP03 ....'
