hidrau
asked on
working with quote
Hello guys,
I am having some trouble to create a string this way
Str = 'Select * from table where field='' september" '
Month := QuotedStr('' " '') + month_alias[StrToInt(Copy( Std[I],5,2 ))-1] + QuotedStr('' " '')
I tried several ways, but nothing so far
As you can see, I have a double quote in september
Thanks
I am having some trouble to create a string this way
Str = 'Select * from table where field='' september" '
Month := QuotedStr('' " '') + month_alias[StrToInt(Copy(
I tried several ways, but nothing so far
As you can see, I have a double quote in september
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much ciuly
month:= quotedstr( month_alias[StrToInt(Copy(
which will result in 'september' for example
if you wan it to put in that select then use:
str:=quotedstr('Select * from table where fieId="+month_alias[StrToI
though in this particular case of yours, I don't really see the need of quotedstr as you do not use single quotes in the string.