>>I'm sure it works, but what is the logic with that? That makes no sense to me at all.
>
>Usually single apostrophe is used as a string terminators (I am not sure about if that term is right). So how to use apostrophe inside the string? There must be a way to let T-SQL know that this apostrophe is not a terminator but a regular char. MS decides to use double apostrophes for that.

Wow, 2 seconds difference in replies!