How to set string variable with " ?
set str1 = "PPP"LegsandHands"";
and this doen't work
How to set up correct?
I want to use this variable like - if (FieldX = $(str1),then,else)
Or this - ... & $(str1) & .... as FieldY
Let str1 = "PPP"&Chr(34)&"LegsandHands"&Chr(34);
Let str1 = 'PPP'&Chr(34)&'LegsandHands'&Chr(34);
May with single quotes around the whole thing?
SET str1 = 'PPP"LegsandHands"';
Guys, where to find all Chr to read ?
Ord() function gives that
like Ord('-') or Ord('"')
Check this out:
How to find a number for a char: chr() and ord() functions
This works too! And more short and beatiful! Thanks!
Retrieving data ...