Total Hits - 38275
Total Votes - 105 votes
Vote Up - 45 votes
Vote Down - 60 votes
Domain - www.databasedev.co.uk
Category - MS Access/Functions
Submitted By - Shekhar
Submitted on - 2008-04-15 07:29:30
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.
Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.http://www.databasedev.co.uk/access-sql-string-functions.html