Similair to the wood-carving device - rou-ted.

ChrisM@Work (9/4/2012)

BrainDonor (9/4/2012)

ChrisM@Work (9/4/2012)

Likewise...

ChrisM@Work (9/4/2012)

Likewise - but...

DECLARE @Version char(40)

SET @Version = 'fiesta zetec 1.2';

SET @Version = CAST(@Version AS Char(38)) + 'BT';

SELECT @Version;

One method - there will be others.

DECLARE @Version Varchar(50)

SET @Version = 'fiesta zetec 1.2';

SET @Version = @Version + ' BT';

SELECT @Version;

Or have I misunderstood the question?

Just to clarify laurie-789651's statement - you'd need to add a column with a default value of GetDate(). This would be a time-stamp, as oppose to a timestamp, which is...

Me too - quite a bit of hunting to get the right answers. Thanks for the interesting question.

I have to say Gail that it was a fascinating thread up to a point, and your examples and explanations...

Thanks for letting me know the cause, I wouldn't have thought of that particular scenario!

Correct, and the OP has already discovered that - http://www.sqlservercentral.com/Forums/Topic1347590-1292-1.aspx#bm1347662.

Yes, and it's quite trivial to try.

Have you taken a FULL backup of this database?

Also known as a Compound Operator, and there are several:

http://msdn.microsoft.com/en-us/library/cc645922.aspx

Although a bit dated (no pun intended) there is an interesting article by Robyn Page for various date and time conversions - http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/.

The easiest way is probably to use the CSV Splitter function, by Jeff Moden (with some assistance from others) - http://www.sqlservercentral.com/articles/Tally+Table/72993/.