Try something like this:

Select cast(client_version as char(1)) || cast(client_level as char(1)) from
nodes


--
Paul Gondim van Dongen
Engenheiro de Sistemas
MCSE
Tivoli Certified Consultant - Storage Manager
VANguard - Value Added Network guardians
http://www.vanguard-it.com.br
Fone: 55 81 3225-0353


-----Mensagem original-----
De: Jolliff, Dale [mailto:xjolliff AT TI DOT COM]
Enviada em: Wednesday, December 18, 2002 15:13
Para: ADSM-L AT VM.MARIST DOT EDU
Assunto: Select statements syntax


I need to create a select statement that concatenates numeric fields as text
-- I need to create a single text field from the four numeric fields in the
NODES table into a single text field.

Once I get the fields CAST as CHAR type, how do I concatenate them?

I tried SUBSTR but it pukes on too many arguments.

This works:

select substr(cast(client_version as char(1)),1,1) from nodes

This doesn't:

select substr(cast(client_version as char(1)),cast(client_release as
char(1)),1,1) from nodes

String concatenation is a basic function, I know it's there, I just can't
remember the function name.