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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jenwinkelman
- Order by date
-
String substitution?
[2thumbsup]Thanks! It worked like a charm. Guess I should have specified that I am using Oracle. I was hoping that it would be as easy as this and I didn't have to write some nasty little function using SUBSTR and concatination.- jenwinkelman
- Post #3
- Forum: ANSI_SQL
-
String substitution?
If I want to convert a white space to an underscore how do I do it? Ex. I have a table with a field NAME. The NAME field always has the format 'ABC x' (where x is a number 0 -255) and I want to convert them all to 'ABC_x'. How do I do it? I need to loop through the table and convert the NAME...- jenwinkelman
- Thread
- Replies: 3
- Forum: ANSI_SQL
