George Woodman wrote: > I have 2 records with the following details: > george,George,george,developer > 1234567890,Temp,0,developer > When I try to retrieve this record with the following statement from a > ASP.Net (VB) app I get no rows returned. > Select * from user_control where uci = 'george' > However this statement works. > Select * from user_control where uci = '1234567890'
Are you sure 'george' does not have whitespace at the end? My bet is that it is actually 'george ' -- Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 "Postgres is bloatware by design: it was built to house PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
