Hi, I'm trying to parse for a numeric string from a column in a table.
What I'm looking for is a numeric string of a fixed length of 8. The
column is a comments field and can contain the numeric string in any
position. I'm not familiar with ActiveX, so any suggestions will be
useful. Thanks in advance.
Regards,
Jai.

Not sure that you can do this EASILY from SQL, but a stored procedure
will be the only way to handle it, methinks.

From a development language like C, the process can be fairly easy,
though, using strchr() and a set of other functions. (Even easier to
do in Icon, but I don't think anyone uses Icon any more...)

What language are you using? Or do you REALLY need SQL-level code to
do this?
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - July 19-22 ***
*** Chicago: Pervasive DataExchange Class - July 27-29 ***


Jai wrote: