SQL String Functions in Microsoft Access

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

SQL String Functions in Microsoft Access

In this article the guys from SQL Book outline some useful functions that can be used in our SQL queries.
http://www.databasedev.co.uk/access-sql-string-functions.html
  • Total Hits: 15089

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 146 votes

  • Category: MS Access/Functions

  • Submitted on: 2008-04-15 07:29:30

  • Submitted By: Shekhar

  • Set as Favorite

Description:

When writing our SQL queries in Access there may be times when we want to manipulate the data that is contained in the columns rather than just returning the whole column value. In this article the guys from SQL Book outline some useful functions that can be used in our SQL queries to manipulate string values and give some real world examples of them in use.

To use these functions we will enter the SQL queries directly into the SQL View of the query designer. To get to SQL View open an Access database then:

Click the Queries tab in the left menu.
Click the 'Design' icon.
Add the table(s) you want to query to the query design view and close the Add table dialog box.
Click the small arrow next to the 'View' icon in the toolbar, select 'SQL View; from the drop down menu.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 37.67%  55
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.27%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.64%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.96%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 29.45%  43

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements