Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010

    Unanswered: converting ASA to ASE sql

    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),

  2. #2
    Join Date
    Nov 2002
    patindex(("loc_st_name",' ')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts