On Sun, 24 Feb 2008 15:35:22 -0500 Drew Jensen <[EMAIL PROTECTED]> dijo: > Your criteria selection is only that criteria for selecting the rows - > it doesn't alter the value in any column - and that is what you need to > do now so you need two of the string functions LOCATE and SUBSTR. You > add a column to sort on that is calculated using these. > > SELECT * FROM "MainBank" > WHERE ( ( "Selections" LIKE '%LFc-___' ) ) > ORDER BY SUBSTR( "Selections", LOCATE( 'LFc-', "Selections") + 4, 3) ASC
That worked. Yay! Thanks for all the help! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
