Can anyone give me some basic help please. I'm just trying to learn to write to SQL to make my job easier.
I've started using variables but the SELECT statement does not work properly when I use it with LIKE and try to surround my variable with % wildcards.
Can anyone tell me the correct syntax please :-
DECLARE @location varchar
WHERE UPPER(DESCRIPTION) LIKE ('%' + @location + '%')
View Complete Post