intersection "where LIKE" QUERY IN sql

Question

what is the syntax of sql query has intersection between 2 "where Like" condition

string command_get_pay = "select Credit 
                            from Update_Company_Credit 
                           where ( Update_Date LIKE '%" + 8 + "%'& Update_Date LIKE 18'%" + 8 + "%')";`

is this true I try it but I got exception in syntax

Answer 1

the & should be probably OR?

Answer 2

Do you mean:

SELECT
    Credit
FROM
    Update_Company_Credit
WHERE
    Update_Date LIKE '%" + 8 + "%'
    AND Update_Date LIKE 18'%" + 8 + "%'
;

Also, LIKE takes a string to use for search, but your second LIKE appears to be invalid... what is 18'%" + 8 + "%')"?

Edit: Oh, this is C#. Still makes no sense: how are you adding a string and an integer?