SQL statement with like cannot get right 1

[TRACEYMARYLAND]

hi i have
select * from INSPHEADER
WHERE SERIAL_NUMBER LIKE 'INT00138' + '%'

but im trying to code in ASP
txtSerialNumber = request("SerialNumber") & " % "
sqlHeader = "select INSPHEADER.SERIAL_NUMBER, INSPHEADER.BASE_ID, INSPHEADER.PART_ID, INSPHEADER.LOT_ID, INSPHEADER.PART_ID, INSPDETAILS.COMPLETED_DATE from INSPHEADER INNER JOIN INSPDETAILS ON INSPHEADER.SERIAL_NUMBER = INSPDETAILS.SERIAL_NUMBER WHERE INSPHEADER.SERIAL_NUMBER LIKE '" & txtSerialNumber & "' "

but getting the string coming out as
Enter Work Order Enter Lot Id
Search By Serial Number


select INSPHEADER.SERIAL_NUMBER, INSPHEADER.BASE_ID, INSPHEADER.PART_ID, INSPHEADER.LOT_ID, INSPHEADER.PART_ID, INSPDETAILS.COMPLETED_DATE from INSPHEADER INNER JOIN INSPDETAILS ON INSPHEADER.SERIAL_NUMBER = INSPDETAILS.SERIAL_NUMBER WHERE INSPHEADER.SERIAL_NUMBER LIKE 'INT00138 % '

how do i code in so that it becomes
select * from INSPHEADER
WHERE SERIAL_NUMBER LIKE 'INT00138' + '%'

 

[Lothario]

Try this:

WHERE INSPHEADER.SERIAL_NUMBER LIKE '" & txtSerialNumber & "%'

WHERE your

txtSerialNumber = request("SerialNumber")

-L