[SOLVED] Stripping Letter in Last Name to First Letter of Name

[TecTao]

I am using a last name query for a list of members in a DB.

I'm a bit confused on stripping the letters down and then out to the first letter of the name such as,

Smith down to "S" or Brown down to "B" so that the query for the letter "S" or "B" returns the names starting with those e letters.

Thanks for any help in advance.
Mike

[fert]

[code]
$letter=$name{0};
[/code]

[Jessica]

Once you have the first letter, then do
"SELECT * FROM table WHERE name LIKE '$letter%'

[subbukumararaja]

$lastName = "George"

now $lastName[0] will return the first letter of the name

so,

[b]select * from table_name where last_name like "$lastName[0]%"[/b]

is this the one that u have asked?

[TecTao]

Thanks all.  The post from Jerirose worked perfectly since I was passing a letter veriable from a previous page.
Thanks for all the help