Getting LIKE %you%

[Kay C Lan]

On 5/25/07, Chuck Pelto <cbpelto at pcisys.net> wrote:
>
>
> SELECT recID, *
> FROM tbl_cont
> WHERE cont_namecomplete LIKE '%May%'
>
> ...seems to be okay.


I'm no expert with SQL but isn't selecting recID & * (ALL) doubling up?

What happens if you just do:

SELECT recID

or

SELECT *

HTH