Nested SQL Replace

[dev at infinitydatasystems.com]

 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