quote:
It's been a while since I done that conversion, therefore I'm not 100% sure, but I think something like this would work
DROP TABLE myName
GO
CREATE TABLE myName(
myn char(10))
go
INSERT INTO myName (myn) VALUES('alfred')
INSERT INTO myName (myn) VALUES('Alfred')
INSERT INTO myName (myn) VALUES('berta')
INSERT INTO myName (myn) VALUES('Frank')
INSERT INTO myName (myn) VALUES('zap')
INSERT INTO myName (myn) VALUES('Zap')
SELECT
*, ASCII(LEFT(myn,1))
FROM
myName
WHERE
ASCII(LEFT(myn,1))>96
ORDER BY
ASCII(LEFT(myn,1))
DESC
DROP TABLE myNameFrank
As the ASCII() just works on the leftmost character of a string, you don't need to use the LEFT() function:
SELECT FName
FROM YourTable
WHERE ASCII(FName) > 96
It's this simple only if the column is char or varchar and the collation supports this, of course...
--Jonathan
--Jonathan