SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: What R These Functions In Access

  1. May 12, 2004 00:49 #1
    arash
    arash is offline
    SitePoint Member
    Join Date
    Apr 2004
    Location
    usa
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    What R These Functions In Access

    Hi;
    1 - convert to lower and upper (in sql) ?
    2- Lpad and Rpad (in sql)
    thank you
  2. May 12, 2004 06:02 #2
    r937
    r937 is online now
    SQL Consultant silver trophybronze trophy
     SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,461
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    1. lcase() and ucase()
    2. no direct equivalent, you will need space(), left() or right(), and concatenation
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"
  3. May 12, 2004 17:33 #3
    MarcusJT
    MarcusJT is offline
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you're using the JET OLEDB driver, I believe you can use the LOWER() and UPPER() functions too.
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code
    - Please think, Google, and search these forums before posting!
  4. May 12, 2004 23:08 #4
    arash
    arash is offline
    SitePoint Member
    Join Date
    Apr 2004
    Location
    usa
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    THANK YOU GUYS.
    i am learning sql in 21 days but on my pc i have ms access , how can i have sql on my pc , is it sth i should buy ?
    thanks
  5. May 13, 2004 03:15 #5
    r937
    r937 is online now
    SQL Consultant silver trophybronze trophy
     SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,461
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    you can download MSDE for free from microsoft

    http://www.microsoft.com/downloads/d...displaylang=en

    download SQL2KDeskSP3.exe (70089 KB) at the bottom of the page
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"
« Previous Thread | Next Thread »

Bookmarks

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