Proper Case in the Query


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Proper Case in the Query

  1. #1
    Join Date
    Jun 2004
    Posts
    288

    Proper Case in the Query

    In the query, I want to display a field in proper case. Is it possible?

    We can use upper/lower , but what is the syntax for proper case?

    eg: LCASE(a.str_inspector)

  2. #2
    Join Date
    Aug 2004
    Location
    Orange, California
    Posts
    1,263
    Look at the StrConv() function. It is normally used to convert back and fourth between normal strings and Unicode strings; but it also has the ability to create proper case strings.
    StrConv(a.str_inspector, vbProperCase)

  3. #3
    Join Date
    Jun 2004
    Posts
    288
    Sir,

    I want to use it in the backend; I mean in SQL Server 2000 query itself.

    thanks

  4. #4
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    SQL Server does not have any built-in way to convert a string to proper case, but I'll bet you can find a solution on the Web by searching for, say, "t-sql proper case." ;-)
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Replies: 18
    Last Post: 12-25-2006, 02:50 PM
  2. errors with some varibles
    By ELHEK in forum Java
    Replies: 1
    Last Post: 10-01-2006, 06:08 PM
  3. Why is this in the console?
    By Dark Rain in forum Java
    Replies: 8
    Last Post: 09-30-2005, 07:42 PM
  4. Run-time error by a blank record made by code
    By VanDam in forum Database
    Replies: 0
    Last Post: 07-09-2005, 05:18 AM
  5. ADOX problem
    By Yoel Martinez in forum VB Classic
    Replies: 1
    Last Post: 12-12-2000, 04:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center