Date Trouble

#1

I have a field called YEAR_FORCAST. It is defined as smalint. I need to
concatenate '01/01' to YEAR_FORECAST and then use the field in a sequel
statement. How would I do this.

#2

Hello DONNA,

How about something like

SELECT '01/01/' + CAST(YEAR_FORECAST as CHAR(4)) as MyConcantenatedValue
FROM ..........

Allan

Quote:

I have a field called YEAR_FORCAST. It is defined as smalint. I need
to concatenate '01/01' to YEAR_FORECAST and then use the field in a
sequel statement. How would I do this.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Date Trouble

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Date Trouble - 06-16-2006 , 04:56 PM

Re: Date Trouble - 06-17-2006 , 06:03 AM