)))
as Level from nodes order by 2,4,1
Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180
-Original Message-
From: Jolliff, Dale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 1:13 PM
To: [EMAIL PROTECTED]
Subject: Select statements syntax
I need to create
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
-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
Thanks to you all, perfect answer!
-Original Message-
From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 12:52 PM
To: [EMAIL PROTECTED]
Subject: Re: Select statements syntax
Way to go Paul !
example run against the occupancy table...
tsm