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 strongm 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: *

  1. jonshin

    Regular Expression Help Needed

    I want to strip all non-alpha numeric chars and replace the first char with "x" if it is a number. I have figured out the stripping of non-alpha numberic chars with the regex below, but how do I replace the first char with "x" if it is numeric? I want to do both operations in the same regex...
  2. jonshin

    Help with Static Crosstab Query

    Exactly what I needed! Thanks Zhavic
  3. jonshin

    Help with Static Crosstab Query

    Using pubs I need to find titles that have exactly 2 authors and display the results like this [title][author1][author2] title1 author1 author2 I have a query that returns in this format [title][author] title1 author1 title1 author2 select t.title, a.au_lname from titles t inner join...
  4. jonshin

    MCSE2k/MCDBA/MCSE200x

    The que books are good and the practice exams (self-test/measureup) will help. There's a Robert Viera book for Sql Server that's good and you'll want to read Inside Sql Server. You should not just read the books, but build databases and learn how to admin them. When you can consistently pass...
  5. jonshin

    MCAD/MCSD - Worth it?

    It helps make your resume stick out. Take advantage of the offer and get the cert...better yet take two more and get an MCSD.
  6. jonshin

    exam type

    Adaptive

Part and Inventory Search

Back
Top