Hi!
I'm using transfer with Oracle as the data backend, and I've come across an annoying problem when sorting. I have a few text fields defined in a table, and I'd like to sort by those fields but with case in-sensitivity. An example: Current order: MARS ATTACKS MORE DATA Mars attacks man on the moon Desired order: man on the moon MARS ATTACKS Mars attacks MORE DATA Usually this is accomplished by issuing an ORDER BY LOWER(title) in SQL, but that's not available in TQL Any ideas, recommendations. I can solve this by adding a view, but it'd be perfect if transfer has something available on this. TIA, Pedro. --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
