LIKE and WILDCARD problems

[slames]

HI I'm using Access 2000 front end on SQL Server backend. I am trying to get a query to execute in VBA code using the LIKE keyword but am having problems with the syntax. Can anyone help? this is my query:

DoCmd.RunSQL "update tblJob set jbCurrentlyBilling = 1 from dbo.tblBook INNER JOIN " & _
" dbo.tblJob ON dbo.tblBook.bkISBN = dbo.tblJob.jbISBN where tblJob.jbBillTag = 1 and tblBook.bkClient = '" & clientToBill & "' and jbISBN like & '" & poToBill & "*" & "'"

Where poToBill is the first five characters of the ISBN number

Any help appreciated,

Thanks

Steph

 

[SkipVought]

Steph,

Is jbISBN a TEXT value or NUMERIC?

You can use wildcard on TEXT but use arithmetic operators for NUMBERS

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[slames]

jbISBN is nvarchar(20) datatype, so I should be able to use a wildcard?

 

[oharab]

Try using the ANSI standard % instead of *

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------