datacolumn.expression with apostrophe in string 1

[SavantMan]

I have a need to set the expression of a datacolumn to calculate based on another field, plus a string. The problem is if that string contains an apostrophe, it's recognized as a a single quote.

ie:

   Dim c As New DataColumn
   c.Expression = "[UserName] & ' is users name'" <-- works fine
   c.Expression = "[UserName] & ' is user's name'" <-- doesn't work

The problem in the second line is the apostrophe is being recognized as closing the literal string.

 

[earthandfire]

Have you tried doubling the apostrophe as in?:

[tt]c.Expression = "[UserName] & ' is user''s name'"[/tt]


Hope this helps

 

[SavantMan]

That's exactly what I needed --- thanks - here's a star