I actually have come across the Urban Dictionary's usage of the word in the UK, but only once and many years ago. So calling it 'common usage' would be exaggerating...

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/.