highv0ltage
ISP
How would I truncate the text from a field in a database.?Would that be done at the query or the ouput of the variable? Also, even though I want it truncated, I would like the full text to be used as the ALT for the link. Thanks.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Truncating Queried Text 1
- Thread starter highv0ltage
- Start date
- Status
- Thread starter
- #21
highv0ltage
ISP
hmmm, nothing i do looks silly. 
Maybe I'll have to use the "select left(daField,instr(daField,' ',1,17)-1)". Thanks.
Maybe I'll have to use the "select left(daField,instr(daField,' ',1,17)-1)". Thanks.- Thread starter
- #22
highv0ltage
ISP
apprently LEFT is an invalid identifer in oracle. any other ideas?
- Status