I've written a SP and it refuses to work with the CONCAT function as documented.
>>Yes I have searched the web and other locales to no avail.
Create Procedure `SP_CODE`(IN search_term VarChar(200))
begin
if search_term is not null then
begin
Select b.s_term, a.O_Number, a.S_CODE, a.LONG_DESC
From JKC a INNER JOIN search_terms b ON a.S_CODE = b.S_CODE
Where b.s_term like CONCAT('%', search_term, '%');
end;
end;
The editor believes that the problem is at CONCAT('%', search_term, '%');
Any ideas what might be the problem would be helpful. THX...