Search code examples
sqlms-access-2010powerbuilder

'MID' is not a recognized built-in function name

I am trying to run the following : 

SELECT auth.c_name,            
    auth.auth, 
    MID( auth.auth, 1 ,1) AS COLUMN_0,
    ( select "function" from key5932 where "key-index" =0 ) as index0,

But i am getting following error: 'MID' is not a recognized built-in function name.

Solution

  • use SUBSTR OR SUBSTRING I forgot it. mid is function properly if java is enabled in ASE.

    Happy coding