Concat a string that already has "&" in it.

[jscriptor09]

Hi

I have this logic that is not working for some reason

str1 = "Apple & Oranges"
str2 = " Dont mix"
str3 = str1 & str2

this gives str3 = "Apple & Oranges Dont mix". I can see it in the watch window.


Now I do this ...
strSQL = "INSERT INTO sometable VALUES('" & _
str3 & "', '" & _
a string & "', '" & _
...
....

Whe I look in sometable, str3 is stored as "Apple & Oranges"



Any idea why this behavior?

Many thanks
Mike

[jscriptor09]

Never mind, I goofed.

The table where it was writing to has the text field length st to a certain value (10 for example). I was not aware of it and wasted 2 hours trying to chase an "&" issue.

Sorry about the post.