Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Location
    Thane, Maharashtra,India
    Posts
    17

    Unanswered: How to replace Ucase() fuction in SQL Server

    an example will be appriciated!!!

  2. #2
    Join Date
    Dec 2004
    Location
    Sweden
    Posts
    74
    select upper('small letters')
    The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

  3. #3
    Join Date
    Feb 2005
    Location
    Thane, Maharashtra,India
    Posts
    17

    Question

    I am developing an application in VB 6.0 which has SQL SERVER which is been migrated from a MS-Access as a database. but in the process the fuctions used are that which are compatable to access and not sql server. How will I make the same application compatable with SQL SERVER?

    EG:-
    1] Ability to convert all the queries using Ucase() without using IF-THEN-ELSE statement.
    like this query:-
    query = "update cus_customer_master set country='" & Address_Module.name_check(cboCountry) & "' where trim(Ucase(country))='" & Trim(Ucase(prev_country)) & "'"

    A solution for the above query must work both in Access as well as SQL SERVER.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by vaisal
    A solution for the above query must work both in Access as well as SQL SERVER.
    good luck

    since you are using a scripting language, i suggest that you make it flip easily between the different versions of sql syntax, but you will probably have to use if-then-else scripting to do so

    wait until you run into a query that involves date arithmetic or LIKE wildcards
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2005
    Location
    Thane, Maharashtra,India
    Posts
    17

    Red face

    I tried to do that, but upper() is not a valid fuction in VB 6.0 and even if I try to use IF-THEN- ELSE then its giving an error.

Posting Permissions

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