Posted by --CELKO-- on 09/25/05 04:46

>> My principal interest was in hearing how anyone else might PARSE the field to recover the data. Erland's trigger idea isn't bad for WHAT I do with it. "Invoice for 1/2 inch puce widgets and a can of beans, 100-3123@WidgetMart" <<

Since free text requires human intelligence, we get people to encode
it. If the text is short and styled the same way, you can find AI
programs that are pretty good these days. Of course this has nothing
to do with RDBMS and nobody in their right mind would try to do it in
SQL.

• Next in forum: Re: Stumped by SQL challenge
• Prev in forum: Re: parsing varchar fields
• Thread view: Re: parsing varchar fields

[Reply to this message]