SQL Query Action Syntax Error

[RRing]

I am trying to substring the insert of the reply field as per below and keep getting an error. I know the ODBC insert replaces the quotes in some manner, but cannot get the below query to work. Can ypou please let me know what I am doing wrong?

Insert into UserCapacity (Eventtime,Folder,Reply) Values (Getdate(),'%Folder%','Substring(%Reply%,CharIndex('Participants=',%Reply%)+13,Charindex('|Conferences=',%Reply%)-charindex('Participants=',%Reply%)-13)')

When Using the following query
Insert into HMCapacity (Eventtime,Folder,Reply) Values (Getdate(),'%Folder%','%Reply%')

Here are results
ACK|Command=ConfCount|MessageNumber=0|Participants=0|Conferences=0|Returned=Success|\r\n\r\n

[KS-Soft]

You should use quotation marks for %Reply% variable

Regards
Alex

[RRing]

Thanks Alex- I missed that. Looks like I had that wrong, and also had to remove the quotes around the complete substring command. All works good now. Thanks you for your quick reply.