> Nick, why would you use a character column in particular?

What Neil said. Also just personal preference - to me, if you define something
as an integer you're implying that it represents a quantity or measurement, you
can do arithmetic on it. etc.

Of course an integer is much more storage-efficient though.

Nick



_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<