"like statement" to compare file directories

(broke hand, excuse the typing)
i have a text file being read by our data management software that is written in vbscript. i have a set of "if thens" that determines what type of id each of our records recieves in the database. these work properly, but i need to add to it and narrow thing down based on a file path. if the file i am entering exists in a certain folder, or any subfolders, i need it to assigne an id based on that, and if not, then it would go on to the next elseif. below is what i have, and i know that the first two lines are written wrong (written in sql), but it might help to clarify what i am trying to accomplish. the rest of it i know works and is what i currently have running, i just need to add this one other option to it.
(forgive me if this is crude or my terminology is way off. i am a mechanical designer stuck setting up our database, so it is all new to me.)

my current code:
if file_directory like "n:\Engineering Data\Software\SolidWorks\Solidworks Data\%" then
DBWOutput "@TEXT", fileName & ", " & material ,ForWriting
elseif configuration = "" or configuration = "Default" then
DBWOutput "@TEXT", filename ,ForWriting
elseif configuration = "---" or (isnumeric(leftconfig) = true and isnumeric(rightconfig) = false) then
DBWOutput "@TEXT", fileName & "(" & configuration & ")" ,ForWriting
else
DBWOutput "@TEXT", configuration ,ForWriting
end if

THANK YOU for any help!!!



Answer this question

"like statement" to compare file directories