Quick SQL question

Klaus major-k klaus at major-k.de
Mon Jul 15 17:43:27 EDT 2013


Hi Pete,

Am 15.07.2013 um 21:43 schrieb Peter Haworth <pete at lcsql.com>:

> On Mon, Jul 15, 2013 at 10:54 AM, Klaus major-k <klaus at major-k.de> wrote:
> 
>> Same value in all columns!
> 
> 
> Hi Klaus,
> OK, should probably be OK then.  

Great, thanks!

> There is one corner case but it's pretty
> unlikely.
> 
> Let's say there is a row with your three columns containing:
> 
> code
> sign
> xyz
> 
> ...and the value you are looking for is "design".  Your concatenated string
> will be "codesignxyz" so the row will be selected even though "design"
> doesn't occur in any of the three columns.
> 
> Pretty unlikely I know but if you want to avoid that possibility, you could
> include some sort of delimiter in your concatenated string, eg:
> 
> col1 || ' ' || col2 || ' ' || col3

thanks, doesn't apply to my needs in the moment but will surely store
this for later reference!

> Pete
> lcSQL Software <http://www.lcsql.com>

Best

Klaus

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





More information about the use-livecode mailing list