Help! Problem with string comparisons

Hi,

I am trying to programatically select a row from a table using string comparisons.

The column in the table is declared as NOT NULL VARCHAR2(9).

I am selecting a field from a Forms 4.5 module, which is a char (9) (and has in fact been selected from the same table).

I assign the value of that field to a variable, Varname CHAR(9); When I do the Select * from table where column = varname, it returns 11k rows instead of 1.

Normally I combat this using rpad and rtrim, thought this is not working. If anyone has any ideas, please help! Many thanks,

Nick

Pilsbury_at_hotmail.com Received on Wed Jan 20 1999 - 09:09:41 CST