Hi
NULL does is not the same as an empty string!
Do you know what value it is passing? It may be a single space? Using
profiler would show the command being executed on your server. Depending on
how you are trying to create the command being sent to SQL Server will
determine what you can do. Using the NULLIF function along with RTRIM may
solve your problem if you are using a passthrough query.
John
"Not Me" <No****@faker.fake.fa.kee> wrote in message
news:cb**********@ucsnew1.ncl.ac.uk...
Hi,
I run a stored procedure with a parameter given from a text box in an
access adp. If the text box is empty then what is passed to the parameter? I
can't seem to get it to flag up as either null, or 0 length.
Any tips?
Cheers,
Chris