Question about prepares -Thanks

Since we don't use prepares here at all. I thought I would take a stab at one of the simpler 4gl reports just to see if I could get it to work. Code fragment compiles fine but blows up at runtime with Program stopped at "glksum.4gl", line number 32. SQL statement error number -201. A syntax error has occurred. Line 32 is the prepare. ... ... ... The logic of the SQL works fine if I hard code the values for fund,sof,and acct inside the SQL. Any thoughts or comments would be GREATLY appreciated. TIA, Craig craig_bedell@ccgateway.amc.edu Many thanks to Alan, Jack et al. who pointed out the missing space at the end of each lin Special thanks to Jonathan Leffler who intuitively knew that I had also not defined my select_stmt large enough to hold the select string. Thanks all, Craig craig_bedell@ccgateway.amc.edu