(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!!!

"like statement" to compare file directories
Northern Rob
RMD
Gautam Vaid
If it helps anyone i can include the entire script (not to long) but i didn't want to throw in a lot of info if it wasn't useful.
CJW99
DamsDev2007
VBScript questions should be posted here:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx dg=microsoft.public.scripting.vbscript
T-SQL:
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=85&SiteID=1