I thought of this, but it won't handle a string with more than one
period. Shucks.
select Val(Paragraph) as Para
from myTable
order by Val(Paragraph)
Any chance of changing the database so that Paragraph = 7.1.2 is stored
as 3 fields: ParaMajor = 7, ParaMinor = 1, ParaReallyMinor = 2?
-David
On Wed, 10 Jan 2001 06:47:49 -0700 "Erika Foster" <[EMAIL PROTECTED]>
writes:
> I have a table that has three fields: Paragraph, Title, Content.
>
> The Paragraph field is a text field, but is the outline number for
> the
> particular paragraph in a document. For example, 7.1.1, 7.1.2, etc.
>
> I need to output these paragraphs in outline order as they appear in
> the
> printed material. Of course, if the paragraphs go past 9, it gets
> all
> muffed up because its a text field and not a number field. Example:
> 7.1,
> 7.10, 7.11, 7.2, 7.3...
>
> Is there any easy way to accomplish this?
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists