Re: Comparing strings as ints

2001-10-30 Thread DL Neil
> I have a table setup with a varchar(20) column, I am using this column to > store a price, the reason I chose varchar(20) is because the prices I am > dealing with are fairly large and I wanted to guarintee 20 digits. There > are no characters like '$' or '.' stored in this column. Now, If I sel

SV: Comparing strings as ints

2001-10-30 Thread Terje Kristensen
select floor('5') <= floor('6'); TK > -Opprinnelig melding- > Fra: Daniel James [mailto:[EMAIL PROTECTED]] > Sendt: 30. oktober 2001 04:32 > Til: [EMAIL PROTECTED] > Emne: Comparing strings as ints > > > Hi Everyone, > > After stari

Comparing strings as ints

2001-10-29 Thread Daniel James
Hi Everyone, After staring blankly at the mysql manual for a long time, I thought it might be time to ask the list... I have a table setup with a varchar(20) column, I am using this column to store a price, the reason I chose varchar(20) is because the prices I am dealing with are fairly lar