Getting LIKE %you%

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> 
> 
> 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

Hi Kay,

Not in Valentina.  RecID is an internal Valentina field, not actually
part of the table schema created by the developer.

Select * 

only selects the user create fields so to get the RecID and all of the
user created fields, you either have to do

Select RecID, *

Or

Select ** (I'm pretty sure ** still works.  I don't usually select all
fields from a table)

-John