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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by JohnnyRocket
-
INSTR from right to left?
I have a column with filenames formatted like blah/blah/blah/filename.txt I just want to display "filename.txt" I have started with: SELECT right(Parameters, instr(Parameters,'/')) From Table Obviously this only removes the first path name. Does anyone know how I can get INSTR to...- JohnnyRocket
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Conditional Concatenation
Thanks very much.- JohnnyRocket
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Conditional Concatenation
Hello, I am writing a query that will determine how many times a given web page is accessed. Each page name is made up of two parts in the table: 1. Target and 2. Parameters. Not all targets have parameters and if there is no parameter the table has a "-" in the parameter column. I...- JohnnyRocket
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
