The below works but only on the first number. The table has the column data type as nvarchar size 13, also tried varchar and float, all types return the same data or lack of. Running MS SQL 2000 STD Ed. SP3.
the sql:
this works
select a, b, c from table where c like '6%';
but this does not
select a, b, c from table where c like '6625%';
There are 13 numbers in the field.
Was able to format the query like the following and it worked;
SELECT *
FROM table
WHERE (C LIKE '6%6%2%5%0%')
the return of numbers started with 66250....
Any ideas?
the sql:
this works
select a, b, c from table where c like '6%';
but this does not
select a, b, c from table where c like '6625%';
There are 13 numbers in the field.
Was able to format the query like the following and it worked;
SELECT *
FROM table
WHERE (C LIKE '6%6%2%5%0%')
the return of numbers started with 66250....
Any ideas?