New to SQL any help is appreciated

[sqlnewbie10]

Hello all,



I have very limited experience with SQL, and I am having trouble executing a query. "Write a SQL statement to display the First and Last Name of students having an a in the second position in their first names"

My query that I executed is:
select first_name, last_name
FROM STUDENT
WHERE FIRST_NAME LIKE'A%';

However, I have tried other wildcard conditions, but it continues to execute the same result which is wrong; the result is just two blank records. Any help is appreciated. I have attached a screen shot to show you what table I am using.

[burrina]

If you ONLY want to see first_name (s) that have a A in them Then

Like "a*"

HTH

[pbaldy]

Again, either the Mid() function or combine the ? And * wildcards.

[June7]

For wildcard usage, review http://office.microsoft.com/en-us/ac...005188185.aspx