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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.