Re: Search for starts with and ends with?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47303
interpreted = N
texte = Two searches. First find all the SKU's that contain 112233 and then the second search of the first result set that finds all SKU's that have an L in them.GK > How can I do this search - I want to search for an SKU that starts with > something and ends with a character. > > For example, my SKU's look like this: > > 112233F00L > 114455G00S > 112233G00L > > > I want to find all SKU's that start with 112233, AND end with L. > > Is there a way to do that, or a way to check the last digit when im doing > the [showitems]? > > Thanks, > Scott ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search for starts with and ends with? (Kenneth Grome 2003)
  2. Re: Search for starts with and ends with? (Gary Krockover 2003)
  3. Re: Search for starts with and ends with? (Donovan 2003)
  4. Re: Search for starts with and ends with? (Paul Willis 2003)
  5. Re: Search for starts with and ends with? (Scott Szretter 2003)
  6. Re: Search for starts with and ends with? (Gary Krockover 2003)
  7. Re: Search for starts with and ends with? (Gary Krockover 2003)
  8. Re: Search for starts with and ends with? (Donovan 2003)
  9. Search for starts with and ends with? (Scott Szretter 2003)
Two searches. First find all the SKU's that contain 112233 and then the second search of the first result set that finds all SKU's that have an L in them.GK > How can I do this search - I want to search for an SKU that starts with > something and ends with a character. > > For example, my SKU's look like this: > > 112233F00L > 114455G00S > 112233G00L > > > I want to find all SKU's that start with 112233, AND end with L. > > Is there a way to do that, or a way to check the last digit when im doing > the [showitems]? > > Thanks, > Scott ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Gary Krockover

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Candle Light Vigil (2001) t or f (1997) syntax question, not in online refernce (1997) WebDNA programmers needed (1998) WC Database Format (1997) Re:2nd WebCatalog2 Feature Request (1996) emailer (1997) Tracking inbound links for discounts (1997) RAM variables (1997) Nested tags count question (1997) Database Advice (1996) SSL (1998) 2.0 Beta (1997) &max= (2003) Date search - yes or no (1997) Multiple catalog databases and showcart (1997) Signal Raised (1997) Grant, please help me ... (1997) [GROUPS] followup (1997) WebDNA/Tenon server consulting near DC (2003)