displaying part of a field

[jennlove]

im new to all this.

what i wanted to do was seach through a database and extract just the first letter from both a field firstname and lastname from table customers.

so i get JD from John , Doe

i got the search okey too look up the names but how do i display them in "JD" just the initials on a new column?

any help would be great.
Thank you in advance

[MAK]

select fname,lname,left(fname,1)+left(lname,1) as Newinitial from tablename

[MAK]

OOPS. I forgot it is MYSQL.
here you go

SELECT fname,lname,CONCAT(left(lname,1),left(lname,1)) from test1;

[MAK]

SELECT fname,lname,CONCAT(left(fname,1),left(lname,1)) from test1;