Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matkwan
Starting Member
36 Posts |
 Posted - 2003-05-03 : 11:09:13
|
| Hi, is there an access sql function to output certain length size of the value ? The values could be very long, I just want to return the first 10 characters.Matthew |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-03 : 11:44:41
|
| The LEFT() function will work:SELECT LEFT(column, 10) FROM myTableThere are also RIGHT() and MID() functions for getting other substrings. The Access help file has more details on them. |
 |
|
|
|
|
|
select length(columnname,10) from table ?