[Babase] lymphstates
Karl O. Pinc
kop at meme.com
Wed Jul 21 12:21:07 EDT 2010
On 07/21/2010 08:32:56 AM, Susan Alberts wrote:
> My only comment on this is that if the column is numeric but coded as
>
> a character it can be very confusing to query because it won't be
> natural or obvious that you need to query as a character, so I at any
>
> rate would often end up writing a query with this statement
>
> Select * from lymphstates
> where state = 1
>
> Instead of
>
> where state = '1'
> For
>
> this reason, if it's numeric it should be coded as numeric and if
> it's a character it would be better to have it as a letter. Does this
>
> make sense? I'm okay with either.
Ok. Makes sense. I'll make it numeric.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list