Recent content by usjTraffic

Thank you 4u2ges :), I tried it and it works. I modified it slightly to suit my scenario as the field contained alpha as well as numeric. Because of that, if displayed numeric as well. In my case, the query looked like this: Fortunately I only wanted a specific match, so I didn't have to...

Hi Richard :) , Thanks for your intro to the books and the w-sites. I find the sqlteam particularly interesting, and would think they offer a wealth of information too, although I may need to crack my head a little to filter through them for similar situations I will encounter. Good one...

Hi, I have been trying to find a function in Ms SQL 2000 to pick up records that match exactly to a string in lowercase. So far, I found that Query Analyser that works closely with the MS SQL Server2000 converts any lowercase values and displays it in uppercase thereby not producing the...

Hi, Being new here, hope anyone can provide some direction. Apart from going and attend a course (which I hope I will have a change to), what is the fastest way to learn this "Transact SQL" (which I think is Microsoft's implementation of SQL in MS Sql Server series) ? Thanks! Any help...