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 myName

Frank

http://www.insidesql.de

http://www.familienzirkus.de

---

SELECT FName

FROM YourTable

WHERE ASCII(FName) > 96

--Jonathan