3 messages in com.mysql.lists.mysqlRe: Asterisks in Integer Columns
FromSent OnAttachments
David Blomstrom06 Jun 2004 11:14 
Daniel Clark06 Jun 2004 11:19 
Michael Stassen07 Jun 2004 13:08 
Subject:Re: Asterisks in Integer Columns
From:Daniel Clark (dcl@nwlink.com)
Date:06/06/2004 11:19:50 AM
List:com.mysql.lists.mysql

One simple option would be to add a footnote column. And add in your code, if
footnote column is NOT NULL then add a * on to population and show footnote at the bottom.

population footnote 100 null 200* yada yada

Suppose I have several columns of numberals - area, popoulation, etc. - and I want to include asterisks and footnotes, as in below:

200 4200 258* 234

24 258<superscript>1</superscsript> 2400

What are some good strategies for doing this? You really aren't supposed to include asterisks in integer columns, right?

It would also be nice to have a strategy that would give you the option of masking asterisks and footnotes when you don't want them displayed.