Loercase query results - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Loercase query results

Author

Topic

sugar
Starting Member

10 Posts

Posted - 2005-07-09 : 15:04:07

hi, im trying to Lowercase my query results and Access says: "UNDEFINED FUNCTION 'LOWER' IN EXPRESION"

This is the regular SQL:

SELECT LocalSKU, QOH
FROM Inventory
WHERE WebItem='YES';

and according to this help page: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_1pki.asp
this is my attemp to lowercase the SKU column:

SELECT LOWER(SUBSTRING(LocalSKU, 1, 20)) AS Lower, QOH
FROM Inventory
WHERE WebItem='YES';

anybody can please tellme what can i do?

thanks in advance

sugar
Starting Member

10 Posts

Posted - 2005-07-09 : 15:18:12

Well, after search in google in found the answer and i glad to imput here:
this is the code wich works in access:

SELECT LCase(LocalSKU) AS LocalSKU, Inventory.QOH
FROM Inventory
WHERE WebItem='YES';

according this webpage: http://www.techonthenet.com/access/functions/string/lcase.htm
and tested here: http://sqlzoo.net/1.htm

thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources