Hi guys!

I am using my Sql server 2000

TABLE:TBLPRODINFO
PRODCODE:CHAR(25)
DESCRIPTION:CHAR(25)
PRICE:NUMERIC(9)

note:
the data prodcode entered/stored is not on the exact fields size

prodcode         description                          price        
-------------------------------------------------------------
hp01                 hewlett packard printer       2500
epson                epson stylus c43                 3500

                    

I Want to get the corresponding value of its price with my inputted prodcode by using these code:

txtprodcode.text=hp01

select * from tblprodinfo where prodcode='"& txtprodcode.text &"'"

but it returns zero in value even it has, he can't find any data, but in ms access it can..

Anybody can help me...

thanks guys

you are using CHAR right? with 25 spaces?

try to use VARCHAR to avoid spaces for your codes


or you can do something like this :

select * from tblprodinfo where rtrim(prodcode)='"& txtprodcode.text &"'"





____________________________
Error 404 ...File not found...!!!!

Thank you very much.. .. but i have also a problem in searching with date

table:tblinfo
dategranted:datetime

how  can i search this in like sele like stmt:

select date like "'& txtsearch.text &"'%'"

he didn't display the any data


so what's problem with this...

thanks in advance

try using this string

"SELECT * from tablename WHERE date like '"& txtsearch.text &"%'"

____________________________
AndreaVB