HELP SQL WILDCARDS PROB

[EjojAnrodac]

Display the last name of all employees who have an 'i' and an 'n' in their last name. IS THIS STILL AN SQL WILDCARDS WITH A COMBINATION OF AN AND? SIGH..PLS. HELP.. :((

[Luc Pattyn]

YES

Luc Pattyn [My Articles] Nil Volentibus Arduum

[EjojAnrodac]

thanks lucy..can you give me some ideas about the query?

[Luc Pattyn]

NO However I could help you when you show what you tried and explained how the results differ from what you want. It isn't my homework. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

[jschell]

EjojAnrodac wrote:

PLS. HELP..

Steps 1. Learn basics of SQL 2. Learn how AND works in WHERE clauses 3. Learn how wildcards work in LIKE expressions. 4. Use 1-3 to determine the answer.

[Corporal Agarn]

Which SQL language are you using? SQL, T-SQL, PL-SQL?

[R Giskard Reventlov]

Let me put you put of your misery: SQL Wildcards[^]. Note the article is very general: you will still have to work out how to apply the information therein.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me