SELECT Line001 + '|' + CONVERT(char(8),GETDATE(),112)
FROM TableName

----- Original Message -----
> From: "Justin Gilli" <[Email Address Removed]
> This works for me. How would I convert the date
> format from Aug 25, 2003 to
> 20030825 (yyyyMMdd) ?
>
> Sincerely,
>
> Justin Gilli
> Systems Administrator
> Wood Flooring International
> 1810 Underwood Blvd.
> Delran, NJ 08075
> 856-764-2501 ext. 119
> 856-705-1177 (direct fax)
> [Email Address Removed] (e-mail)
> www.wflooring.com (web)
>
>
> -----Original Message-----
> From: Jonas Skafte Jensen
>
> Maybe something like:
>
> SELECT Line001 + '|' + cast(getdate() as varchar)
> FROM TableName
>
>
> HtH
>
> Jonax
> ----- Original Message -----
> From: "Justin Gilli" <[Email Address Removed]
> I am looking to append a date variable in a stored
> procedure.
> For example I have a table with a column named
> Line001
> I want to show the column results but also append
> the current date,
> something like - "ResultsLine001|082503"
>
> Any advice?
>
> Sincerely,
>
> Justin Gilli

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
MS Sql Server LazyDBA home page