did you try single quotes?
[EMAIL PROTECTED] wrote:
I have an Access datasource for movie listings. mTitle is the
column/field for the movie's Title. I need to output the records
ordered by mTitle, however I need to ignore "the" when it is the first
word.
For example: The Big Lebowski should be ordered by B in Big, not T in The.
My solution was to create an alias column in my query wherein I
REPLACEd "the" with "" and then ORDER BY the alias column.
SELECT
mTitle,
REPLACE(mTitle, "the", "") AS titleOrder
FROM
movieTable
ORDER BY
titleOrder
However, when I run this I get an error that the function REPLACE is
undefined:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Undefined function 'REPLACE' in expression.
I have "Googled" for an answer to my problem (till I'm blue in the
face) but can't find anything HELPFUL.
Can anyone help OR suggest a different solution?
Thanks,
Dan Kaufman
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
