Ooops sorry i figured it out, it is possible.

Thanks,

Enzo :)

-----Original Message-----
From: enZo :-) [mailto:enzaux@g...]
Sent: Tuesday, September 17, 2002 4:51 PM
To: sql language
Subject: [sql_language] String concatenation in SQL statement



	Is it possible in an SQL statement to have string concatenation.  For example, I have
a data (Field1) "2002",  I would like only to get "02" from Field1. Is that possible thanks.


Enzo
YahooID: onestepcloser2insanity