[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