Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Like Function for vbscript

Author  Topic 

liakamai
Starting Member

4 Posts

Posted - 2006-02-22 : 19:22:56
Greetings,

I'm pulling my hairs out.

I can't seem to find a like function anywhere, any suggestions?

myRef = "3-ABCD-ABC-1234"

I'm trying to convert this vba code to vbscript for a function I'm writing in DTS.

If myRef Like "#-[A-Z][A-Z][A-Z][A-Z]-[A-Z][A-Z][A-Z]-[oO0-9][oO0-9][oO0-9][oO0-9]" Then

'do something

End If

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-22 : 19:43:48
I googled VBScript + Like + Operator and found these:
http://www.windowsitpro.com/Article/ArticleID/5882/5882.html
http://www.sunny-beach.net/manual/249.htm


Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -