[PERFORM] NUMERIC x VARCHAR

2004-08-10 Thread Er Galvão Abbott
Greetings. I have a question regarding performance of certain datatypes: I have a field where I will store my clients phone numbers. I know that this field will never exceed 15 characters, and I will store only numbers here (no dashes, dots, etc...), so I was wondering: Wich type is faster:

Re: [PERFORM] NUMERIC x VARCHAR

2004-08-11 Thread Er Galvão Abbott
Thanks, Michael. You and "Evil Azrael" (lol) got me. Never thought about leading zeros. Varchar it is! Thanks a lot, -- Er Galvo Abbott Desenvolvedor Web http://www.galvao.eti.br/ [EMAIL PROTECTED] Michael Glaesemann wrote: On Aug 11, 2004, at 4:27 PM, Er Galvo Abbott wrote: It