Hi,

Does Elevate have the equivalent of the SQL functions ASCII and CHR found in other implementations?  I couldn't find anything in the docs.


Thanks

<< Does Elevate have the equivalent of the SQL functions ASCII and CHR found
in other implementations?  I couldn't find anything in the docs. >>

Are you looking to just insert a specific character as a constant ?  If so,
then you can just use this:

SELECT 'This is on one line'+#13+#10+'This is on a different line'
FROM MyTable

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<< Does Elevate have the equivalent of the SQL functions ASCII and CHR found
in other implementations?  I couldn't find anything in the docs. >>

Are you looking to just insert a specific character as a constant ?  If so,
then you can just use this:

SELECT 'This is on one line'+#13+#10+'This is on a different line'
FROM MyTable

--
Tim Young
Elevate Software
www.elevatesoft.com


Hi Tim,

No, a table of mine has a character field defined as a space if the entry is current or A,B,C,D, etc.  if the entry represents an older "retired" entry.  I just wanted to be able to convert this A,B, etc to a number the same way I can with my-sql by saying I =  ASC(f_stat_field) - 65 to have I=0 when the field is 'A', 1 when the field is 'B', etc.    

Thanks

mferan


For that you could use POSITION eg

POSITION(f_stat_field IN 'ABCDEFG.....')

You could also create your own function using Tim's SQL/PSM which you can then call so you can have exactly the same call as in mysql.

Roy Lambert [Team Elevate]

Dear mferan,

There are a good number of internal functions in EDB such as:

SUBSTRING
LENGTH
OCCURS
POSITION

which can be used to determine whether particular CHARs or strings occur in a source field, or to copy out subsections of a field to do comparisons on.

You also have IF

i.e.

IF(SubString(somefield FROM 4 FOR 1) = 'A' THEN DoSomething ELSE DoSomethingElse)

--

I don't think there is an ASCI function to convert a CHAR to its ASCI representation, but I have never needed to use one myself, as I would usually just quote the CHAR direct (i.e 'A') .

If you need to identify non-printing CHAR (i.e. [RETURN]) you can use #10, #13 etc.