That did the trick. Thank you all

For some reason, i'm getting all twisted up and bumfuzzled here.

First off, where is this variable "NewValue" getting used once it's cast? Doesn't appear anywhere in the statement...

Thanks. However, i'm getting the following with the Select statement:

Msg 402, Level 16, State 1, Line 1

The data types text and varchar are incompatible in the add operator.

Both...