Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: out of curiosity


Message #1 by "Evan" <raisorsharp@h...> on Sat, 7 Sep 2002 15:16:33
JUST OUT OF CURIOSITY

I'm writing a few Stored Procedures and found out that I "Cannot?!?" use 
the char (10) in the form of:

@MyCodeVar char (10),
etc. etc.

I mean, the FIELD value that I compare the @MyCodeVar is actually char 
10, but when I submit it to the (from an ASP page) sp like that, nothing 
comes up.

Changing the @MyCodeVar to varchar (10) everything goes 
fine.......similar thing with DATE, but I'm sure that has something to do 
with the time being behind it and all.

Yours Truly

Ewout Kozel

  Return to Index