MI-L Server_Execute sql strings

[Mark Williamson]

Hi

I cant seem to add a number into an sql string for the Server_Execute statement. I'm 
using Format$(<num>,"") to 
get back a string to add to the statement but it doesnt seem to like it.
stmt = Server_Execute(conn, "SELECT * FROM poiCategory WHERE categoryId = " + 
Format$(1,""))

any ideas gratefully received



Thnaks



Mark