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:[EMAIL PROTECTED]] Enviada em: Wednesday, December 18, 2002 15:13 Para: [EMAIL PROTECTED] 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.
