Guest User

create asp.net a-z list

a guest
Feb 27th, 2012
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. select word from
  2. (select word from table
  3. union all
  4. select Upper(Substring([word],1,1)) as letter from table
  5. ) t order by word
Add Comment
Please, Sign In to add comment