sql server mseq: Can I use a wildcard in my query, lets say I have few
entries in the table starting
with "wonder01,wonder02...wonderxx..) also how about the
date what if i want to find all the record entered in july
this year only? how do i go about it.

O. Djoudi,

[quoted text, click to view]

Yes, you can use wildcards for strings:

select * from SomeTable
where SomeColumn like 'wonder%'


Use comparison operators for dates:

select * from SomeTable
where SomeColumn >= '20030701'
and SomeColumn < '20030801'

or

(if your dates have no time portion)
select * from SomeTable
where SomeColumn between '20030701' and '20030731'


Linda