Can I sort by multiple codes within a field?

[fgw13]

I have just starting using Paradox 8 and canot find information about whether I can sort within a field, i.e. if I put several 3-letter codes in one field, can I do a query that asks for all records with one or more specific of those codes or do I have to create separate fields for each code to be able to sort by individual codes? Any suggestions on most effective way to proceed? thanks
fgw13

 

[Kliot]

FGW13

If I'm understanding you correctly then yes, you can do a query for extracting data based on a character in the 3 character field. Such as if you want to find all records where the second letter is a "M" you could query for "@M@", or for the third letter "@@M" etc. You however can only sort a table on the first character in a field, you may find you will get better flexibility by breaking this up into 3 fields.

Hope this helps
Perrin

 

[footpad]

fgw13,

Depending on your knowledge of SQL, you may also be able to calculate a sorting value in the SQL query and then use the ORDER BY clause to return the results in the order you're after.

Hope this helps...

-- Lance

 

[Langley]

You can use the .. and OR operators in the query if the codes are unique enough.

..ABC.. OR ..XYZ.. OR ..LMN..



Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us