Nested SQL Replace

Infinity Development dev at infinitydatasystems.com
Mon Dec 27 13:59:22 CST 2010


Never mind... I found my mistake.

Matt

dev at infinitydatasystems.com wrote:

> I seem to be having a problem with nested SQL Replace commands using 
> the SQL method. Here's the select statement:
>
> "select replace( replace(subject, 're:', '') subject, 'fw:', '') As 
> subject, RecID from tblEmails"
>
> As long as only 1 replace is used Valentina returns the results as 
> expected. But with the nested select statement I get the following 
> error:
>
> "line 1:45: expecting ')', found 'subject'"
>
> What am I doing wrong?
>
> Thanks
> Matt
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.


More information about the Valentina mailing list