"SELECT * FROM User WHERE usrid.usrid = ' administrator ' AND
usrid.passwd=CONVERT(varbinary, '" & vbString & "')"

It said the vbString column doesn't exist.
But actually it is just a String.
How can I tell SQL Server 7 that it is a String(nvarchar) but not column ?

thanks for help

You statement should be something like this:
"SELECT * FROM User WHERE usrid.usrid = 'administrator' AND
usrid.passwd=" & CONVERT(varbinary, vbString)

Any string that you wanted to included from a variable should not included
in the paranthesis " ".

Hope this helps

--

Regards,

David Voo