On Nov 6, 2005, at 8:19 AM, Bjørn Eikeland wrote:
Two columns, 'rr' and 'slag', 'rr' contains precipitation and 'slag' contains the type of precipitation as a two letter code. RR (capital) is the code for rain, but any and all select statemens includeing WHERE slag="RR" fails as it thinks I'm comparing 'slag' to the column 'rr'..
use single quotes WHERE slag = 'RR' -- Puneet Kishor