SQL Concatenation

["Ginga2050" <c.p.notman@xxxxxxxxxx>]

Hi, 

 Can anyone help me with this no doubt simple query. 

 SELECT Authors.authorID, Authors.lastname, Authors.firstname, [firstname] & " 
" & [lastname] AS fullname,
 FROM Authors
 WHERE [firstname] & " " & [lastname] LIKE '%#indexsearch#%' 

 at the moment all i get is

 Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft 
Access Driver] Too few parameters. Expected 1

 Any help would be most welcome :-)

 Thanks

 Craig.