Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help! Problem with string comparisons

Help! Problem with string comparisons

From: Pilsbury <Pilsbury_at_hotmail.com>
Date: 20 Jan 1999 15:09:41 GMT
Message-ID: <01be4486$e50355a0$0159ea9e@mothergoose>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US