matching pattern

[omozali]

Hi

I have the following problem

I have a string that will contain 16 numbers , ones or zeros in unknown order
How can I find out if the string will have a zero or zeros between atleast two ones

for example something like 1110111111001111

[nico5038]

Try a LIKE with wildcharacters like:

select * from tblX where YourField like '*11*0*11*';

This will allow any number of zero's between 11 and 11 and that string can be located anywhere in the string.

Nic;o)

[NeoPa]

Hi

I have the following problem

I have a string that will contain 16 numbers , ones or zeros in unknown order
How can I find out if the string will have a zero or zeros between atleast two ones

for example something like 1110111111001111

If you meant :

How can I find all strings which have at least one zero between any two ones

Then Nico's answer is easily amended to :

SELECT * FROM tblX WHERE YourField Like '*1*0*1*';