(255),m_day)) + '/' + convert(varchar (255),m_year)) as date
from myTable
that is, if sqlserver is your database!
its the + sign plus the '' filled with whatever
delimiter you choose. The "CONCATENATOR" :)
hth
tw
-----Original Message-----
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 12:48 AM
To: CF-Talk
Subject: SQL Help
I have a database where the day, month, and year are stored as ints.
When I
select these 3 columns, I want to make them into a date. Something along
these lines:
SELECT (m_day, m_month, m_year) AS m_date
FROM myTable
Obviously that doesn't work, but is there a way to concatenate the 3
ints to
create a date in the select statement like that?
Cedric
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
