DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 16

Thread: How to get the substring value from a column with data?

Threaded View

  1. 04-15-2004, 11:45 AM #6
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    translate(initcap(column),
    'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',
    'ABCDEFGHIJKLMNOPQRSTUVWXYZ')
    Will deal with any number of names - but I feel there must be a neater way . . .
    Last edited by DaPi; 04-15-2004 at 11:48 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width