Skip to Content
0
Former Member
Jan 13, 2012 at 07:57 PM

is there a "LIKE" command when creating a function in the SBO tool

22 Views

When creating a Function in SBO is there a "LIKE" command. It' doesnt complain about it when I check for errors, however at the same time it doesn't seem to work, maybe I need a wild card???

if (upper($P_STR_STREET) like 'PO BOX')

begin

$P_STR_STREET = replace_substr(upper($P_STR_STREET),'PO BOX','');

end