Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field withone chercter and rest are number
Message
From
17/10/2002 17:08:45
Liam O'Hagan
O'Hagan Programming Ltd
Ireland
 
 
To
17/10/2002 16:59:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00712598
Message ID:
00712610
Views:
9
Hi Bill


Index On Iif(IsAlpha(Substr(fieldname,1,1)), Substr(fieldname,2), fieldname) tag sometag


Liam


>Hi all
>
>I have filed that start with contains a character and then numbers and I want that it should be sorted on the number, but some times it has only a number with out any characters so I do id it
>
>thanx all
Liam O'Hagan
MCP VFP Desktop Apps
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform