Hi all,
I use vb.net and TableAdapter. I want to check the @field value include empty string then will adjust the value to NULL.
Anyone know how can i do, eg. if the @lineno is " " then change to NULL ?

INSERT INTO item (itemcode, lineno) values (@itemcode,@lineno)

thank you