Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trucate text value in Select statement
- Thread starter jase2006
- Start date
This will differ from database to database.
You will want to look into the SUBSTRING function for your particular database.
Here are some options for how to get the position of the space (which you will need to know how many characters to take with SUBSTRING):
SQL Server: CHARINDEX, PATINDEX
MS Access: INSTR
ANSI-SQL Equivalent: POSITION
Hope this helps,
Alex
[small]----signature below----[/small]
I don't do any programming whatsoever
Ignorance of certain subjects is a great part of wisdom
You will want to look into the SUBSTRING function for your particular database.
Here are some options for how to get the position of the space (which you will need to know how many characters to take with SUBSTRING):
SQL Server: CHARINDEX, PATINDEX
MS Access: INSTR
ANSI-SQL Equivalent: POSITION
Hope this helps,
Alex
[small]----signature below----[/small]
I don't do any programming whatsoever
Ignorance of certain subjects is a great part of wisdom
- Status