Hello,

Sergey has provided why the temporary cursor isn't usable after the parameterized query ..

so why don't just build the select statement statically .. e.g.:

TitleName = "Owner"
lcSQL = "SELECT * INTO #TempCustNew FROM Customers WHERE RTRIM(ContactTitle) = '" + ALLTRIM(TitleName) + "'"

? SQLExec(hConn,lcSQL)
? SQLExec(hConn, "select * from #TempCustNew where rtrim(City) = 'Nantes'") && now should return 1

Regards

Christian