remind me how to use like

Guy Cohen · Joined: 04 Oct 2007 Posts: 27

Hi all
I want to verify a string.
The string should include only A-Z,0-9 and

Please remind me how to use Like operator
TIA
Guy

Archived from group: microsoft>public>vb>syntax

Larry Serflaten · Joined: 04 Oct 2007 Posts: 2644

"Guy Cohen" wrote
> Hi all
> I want to verify a string.
> The string should include only A-Z,0-9 and
>
> Please remind me how to use Like operator

How about hightlighting the word LIKE in the code editor
and pressing F1? There is too much there to try to cover it
all in a single post. Also check out the examples....

LFS

Randy Birch · Joined: 04 Oct 2007 Posts: 1768

x Like "*[!0-9a-zA-Z]*"

--

Randy Birch
MS MVP Visual Basic
http://vbnet.mvps.org/

Please reply to the newsgroups so all can participate.

"Guy Cohen" wrote in message @TK2MSFTNGP03.phx.gbl...
Hi all
I want to verify a string.
The string should include only A-Z,0-9 and

Please remind me how to use Like operator
TIA
Guy

"Rick Rothstein \ · Joined: 04 Oct 2007 Posts: 1584

> > I want to verify a string.
> > The string should include only A-Z,0-9 and
>
> x Like "*[!0-9a-zA-Z]*"

You forgot the NOT and the SPACE...

If Not X Like "*[!0-9a-zA-Z ]*" Then 'ok

Rick

Raising an event from Windows Control Library Hi I am in the process of attempting to migrate from vb6 to visual basic 2005. I have a vb6 activex component which uses the winsock and a vb6 program which responds to events from within the activex component. For example if the activex received data fr

could u help me how to connect access database using adodc hi, could u help me how to connect access database using adodc

Accessing SDF Database Formats Does anyone know if it is relatively easy to access SDF (SQL Server Compact Edition) databases from VB - desktop app, not mobile? Are there a set of free data access objects out there (boss has a bit of a phobia about third-part components.)? -- Regards,

Is there any way to detect Standby? Is there any way VB6 can detect that the machine is about to go on Standby, or that it has just returned from Standby? Likewise, is it possible to detect Hibernation, either before or after the fact? Any help would be appreciated. -- Dale Beckett

Permissions Issue with XP SP2 and Use of Access Database wit I have VB6 app that uses a MS Access database to store information. In the past, I placed the mdb file in the Application folder. With XP SP2, however, no one had write permissions on that folder and they cannot open the database (because the ldb file c