[thelist] help with query Part I
Casey
aspnet at thecrookstons.com
Mon Oct 31 22:23:49 CST 2005
> : OK, the db in question had a column called mls
> : containing an id. All id's in this column start with
> : a 0... some are 07xxxx, some are 06xx, etc. There
> : is no set number of total digits. I need to
> : select only the rows where mls
> : starts with 06.
> :
> : How would such a where clause be formatted?
>
> Since you don't tell us what DBMS you are using, all I can suggest is that
> you go and look in the manual for whatever DBMS you are using, and look up
> the string formatting functions you have available to you.
Details... details....
MS SQL classic ASP. I guess I thought that this was a simple enough query
question that it didn't matter.
Would -- WHERE mls LIKE '06%' -- do the job?
Casey
More information about the thelist
mailing list