SQL Query - Like (wildcard) Function!!!

Results 1 to 2 of 2

Thread: SQL Query - Like (wildcard) Function!!!

  1. #1
    Join Date
    Dec 1969

    Default SQL Query - Like (wildcard) Function!!!

    Below is my script:<BR><BR>Set RC1 =CTD.Execute("select RETDOCID, STSDESCR, RETUDATE, Replace_Item_Number, Bill_of_Lading, SHIPMTHD from SVC05000 INNER JOIN SVC05500 ON SVC05000.RETSTAT=SVC05500.RETSTAT where ZIPCODE=&#039;"& zip &"&#039; and RETDOCID like &#039;"% retdoc %"&#039;")<BR><BR>Some how it doesn&#039;t like the "like" function when zip and retdoc are the value enter by the user... retdoc need to be wild card, user only need to type in a portion of the retdoc to get the return data...<BR><BR>Please advise!!!<BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: SQL Query - Like (wildcard) Function!!!

    and RETDOCID like &#039;%" & retdoc & "%&#039;")<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts