Select Upper(fieldName) as UField from TableName should work.. there is no replacement that i know of. Curious.. what is the Sql DataType?
ColdFusion its UCase(String) Joe ----- Original Message ----- From: "Brian Scandale" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 12:01 AM Subject: SQL Upper Function Replacement? > What replaces the SQL UPPER() function ins SQL Server? > > It's used to return the upper case of it's argument... It's complaining that > "Argument data type text is invalid for argument 1 of upper function" > > thanks again! > > ~Brian > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
