Parameter value from empty text box - null or 0 length? -- sql server (alternate)

Not Me
6/28/2004 1:27:42 PM

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

John Bell
6/29/2004 8:05:41 AM

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

[quoted text, click to view]

sql server (alternate) : Parameter value from empty text box - null or 0 length?