SQL question

[Klaus on-rev]

Hi Peter,

Am 19.09.2012 um 18:21 schrieb Peter Haworth <pete at lcsql.com>:

> On Wed, Sep 19, 2012 at 3:07 AM, Klaus on-rev <klaus at major.on-rev.com>wrote:
> ...
>>> Klaus, have you implemented a solution to this yet?  I don't recall you
>>> mentioning which flavor of SQL you're using and that makes a difference.
>> ah, sorry, I will use a local SQLite database.
> 
> OK, good to know.  I don't remember all the solutions you've been given,
> but here's a couple of notes.  Apologies if you already know this.
> 
> If you concatenate columns together, the operator to do that in sqlite is
> || not +.
> 
> I think there was one solution that used PATINDEX - sqlite doesn't have
> that function.

OK, thanks for the info!

> I implemented exactly the same functionality in a name/address search db
> once and ended up biting the bullet and using a WHERE clauses that tested
> every column in the table for the string I was looking for.  A pain to code
> because I probably had 20 or 30 columns to search but sometimes the
> simplest solution is the best :-)

I am sure I have some old "SQL statement generator" script somewhere on my HD
which will do the work for me :-)


Best

Klaus

--
Klaus Major
http://www.major-k.de
klaus at major.on-rev.com