The way I would approach this would be to have a user defined table function that splits out your country string and returns a table.

Your query would then become

SELECT *...

The RedGate software site has an article by "Phil Factor" lamenting the fact that you have to leave your techy past behind you to get into the higher echelons of...

numeric fields can hold values to 2*10^+-38 where as integers are 2*10^+-31 so if you need more than 4 billion values then numeric fields offer a solution.

Storage size for Numerics...

As a DBA my main concern is with apps developers who code things up with the assumption that they will have access to the SA password or similarly excessive access...

If stress makes you crack then you are damaged for life.

You can x-ray broken bones, examine stitches and wounds, but there is no empirical measure for a broken mind.

It...

My apologies for "Simplicity Stake". Guess who wrote the article late at night on using a cheap keyboard?

Back in the days of SQL 6.5 Enterprise Manager was known as Enterprise Mangler.

Personally I prefer to use T-SQL Scripts because I can save them and re-use them without...

SELECT DISTINCT will produce 1 record for every occurrence of the items in the SELECT list.

In the first example if you have two shared ID values then only one will...

Apart from VB and SQL are there any other current computer languages that are not case sensitive by default?

So you are trying to extract the date from a filename and use that as the sorting key.

Where a date cannot be found you are just going to sort by...

I've no idea. Frankly I would be amazed if it were true.

The only possible benefit that springs to mind is if you use the table hint NOLOCK then you...

Almost any commonly used expletive will do as a name of SMSS.

You have quite a mix of terms above.

Query Analyser is SQL 2000 and below but you mention SQL2005?

If you are using SQL 2000 try using an IMAGE or VARBINARY fields...

If you write crap code in PHP/MySQL then it is just a susceptible to hacking as for anything else.

Although PHP is popular the number of PHP programmers is dwarfed by...

When I worked for a company supplying solutions the attitude was altering the source code violated any support contracts.

It was a business issue not a technical issue