i have written a bunch of sql in ASA and am now trying to convert it to ASE.
the asa function LOCATE in not running is ASE. is anyone familiar with an ASE function that is similar to the ASA LOCATE function?

thanks for your time.

substring("loc_st_name", LOCATE("loc_st_name",' ',1)+1 ,2),