sinqle quote prefix

[don2241]

Hi,
I am trying to have a sinqle quote as a prefix from a select statement.

My data in the database might look like: 000123456
In my select statement I want to be able to have code that would output the above data like: '000123456

I have tried: chr(39)|| [field name] but that did not work. Any suggestions

/Martin

 

[BrianTyler]

It works for me.

Is field_name numeric. It must be for concatenation. If not use chr(39) || char(field_name)

Good Luck

Brian

 

[don2241]

Hi
[field_name] is not numeric, it is a character field. This is the error message I get when using chr():

Warning: SQL error: [unixODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - CHR in *LIBL type *N not found.,

As far as I know we should have chr() function in our libary, or might I be wrong?

I do not know if it matters but the whole query is sitting inside double quotes because the query is stored, and used, as a variable

/Martin

 

[ddiamond]

I am using version V5R2 of OS/400. That version does not appear to have the chr function. The following should work, however:

select '''' || field_name from table_name