Stored procedure calling a char based parameter

[mattbrenn]

SQL2K
Hi,


I've created a stored procedure with a CHAR datatype as the parameter that is passed to it and cant seem to get it to work. I've tried using different fields with different datatypes such as int and numeric and its successful. Is there a problem using a Char datatype as a parameter, if so is there a way around it?
TIA
Matt
(New to SQL)

Stored procedure
@PONUM CHAR

tables etc

Where
( POP_HEADERS.PO_NUMBER = @PONUM)


query analyser


EXEC POPRINT @PONUM ='100051'

 

[2ni]

if you don't specify the size of ur char the default value will be 1

so what u wrote means @PONUM CHAR(1)

then if the field PO_NUMBER is a numeric field u'd better use an numeric parameter

 

[mattbrenn]

Thanks for the tip its very much appreciated
Worked first time.
Best regards
Matt