Home Forums SQL Server 7,2000 General Update through wildcard string search RE: Update through wildcard string search
Razvan Socol
SSCarpal Tunnel
Points: 4783
More actions
October 20, 2004 at 12:24 am
#527271
Hmm... maybe your Name column (in table A) has the char datatype (I expected it to be varchar). In this case, try:
SELECT b.*, a.code FROM a INNER JOIN b ON b.text LIKE '%'+RTRIM(a.name)+'%'
Razvan