Published on InterSystems Developer Community (https://community.intersystems.com)

Home > %Startswith or LIKE?

Question
Hao Ma · Feb 24, 2020

%Startswith or LIKE?

Could anyone please explain why Caché has a %STARTSWITH function while it supports ANSI SQL "LIKE"?

 

thank you very much.

#Performance #SQL #Caché #InterSystems IRIS

Source URL:https://community.intersystems.com/post/startswith-or