Thanks Michael,

lnResult = SQLEXEC(x, "SELECT @@SERVERNAME", "c_servername")

Missing the first quote on result cursor name.

It works in MS SQL Server 7.0. I'll test it for 4.2.

Thanks again for the fast response.

Paul de Niverville


>You can reference the @@SERVERNAME global function.
>
>
>hConn = SQLSTRINGCONNECT()
>lnResult = SQLEXEC(hConn, "SELECT @@SERVERNAME", c_servername")
>SQLDISCONNECT(hConn)
>
>-Mike