VBscript using lrim and rtrim - SQL

[MavrickStl]

I am trying to use ltrim and rtrim in a SQL statement within my ASP code as follows:

sqlnew = "Select Goal_id,det_id, desc1 from brag_det where" sqlnew = sqlnew & "user_id= "&varuser&" and mon="&varStoremon&"""

I would like to use ltrim and rtrim on desc1 column as follows:

Ltrim(rtrim(desc1,'"'),'"')

as follows:

sqlnew = "Select Goal_id,det_id, Ltrim(rtrim(desc1,'"'),'"') from brag_det where" sqlnew = sqlnew & "user_id= "&varuser&" and mon="&varStoremon&"""

but i am getting this oracle error:

ORA-01756: quoted string not properly terminated.

can anybody help me out?

 

[tsuji]

Hello, MavrickStl.

Simply put :

sqlnew="Select Goal_id,det_id,"&trim(desc1)&" from brag_det where "

sqlnew=sqlnew&"user_id="&varuser&" and mon=" &varStoremon

(Of course, care of leaving one blank space before FROM and after WHERE above. Also shoud MON be read as MON=?)

regards - tsuji

regards - tsuji