sql command error [modified]

[khosnur]

Dear Get the list of Customers where Company Name's 2nd letter is Consonant. (Table: Customers) i am using northwind database.plz tell me how to solve that problem. any comments are highly appreciated. Shafik

modified on Thursday, August 4, 2011 3:45 AM

[Simon_Whale]

What have you tried? Are you using SQL? ADO.NET? LinQ?

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

[Lost User]

You haven't mentioned what database you are using. For MS SQL Server, it would be:

SELECT * FROM Customers WHERE SUBSTRING(CompanyName,2,1) NOT IN ('a', 'e', 'i', 'o', 'u')

[Tim Carmichael]

What is the second character in the computer name is not a letter, like O'Darby?

[PIEBALDconsult]

Oh, well then... You'll need two more tables:

CharacterClass
ID CharacterClass
1 Vowel
2 Consonant
3 Digit
4 Symbol
5 Whitespace

Character
Character CharacterClass
A 1
B 2
...

Then simply JOIN. :jig:

[Tim Carmichael]

PIEBALDconsult wrote:

Oh, well then...
 
You'll need two more tables:

I know that.. I wanted others to think the answer through...

[GenJerDan]

Chances are the O' folks never made it into the database because parameters were not used for the input, and no one did a .Replace("'","''") on the SQL string, so it's not an issue.

It always itches for the first week or so. My Mu[sic] My Films My Windows Programs, etc.

[Lost User]

The code was just a heads-up to get the OP started with something. I'd have suggested something better if the OP came back with the specifics.

[jschell]

:) Or because the GUI specifically excludes those because the developer doesn't know anyone with a name like that.

[PIEBALDconsult]

Isn't that just the luck of the Irish. :~

[PIEBALDconsult]

I thought I was being facetious in my over-engineering way. :-D