what about: SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' ' containing ' '||@po||' '
Cheers,Tjioe On Saturday, November 30, 2019, 02:20:00 PM GMT+7, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote: On 29-11-2019 22:52, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > The fstName is the column title, not the value. I'm using embedded > Firebird. That you're using Firebird Embedded doesn't matter, it works exactly the same as Firebird Server for queries. The problem is that your using two conditions on column fstName using AND. That means for a single row both conditions must be true for that column. The conditions lower(fstName) LIKE lower(@p0) AND lower(fstName) LIKE lower(@p1) will only be true if both @p0 and @p1 can match the same value, which I think is unlikely for a column which contains first names. Maybe you meant OR instead? Mark -- Mark Rotteveel #yiv9860211115 #yiv9860211115 -- #yiv9860211115ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9860211115 #yiv9860211115ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9860211115 #yiv9860211115ygrp-mkp #yiv9860211115hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9860211115 #yiv9860211115ygrp-mkp #yiv9860211115ads {margin-bottom:10px;}#yiv9860211115 #yiv9860211115ygrp-mkp .yiv9860211115ad {padding:0 0;}#yiv9860211115 #yiv9860211115ygrp-mkp .yiv9860211115ad p {margin:0;}#yiv9860211115 #yiv9860211115ygrp-mkp .yiv9860211115ad a {color:#0000ff;text-decoration:none;}#yiv9860211115 #yiv9860211115ygrp-sponsor #yiv9860211115ygrp-lc {font-family:Arial;}#yiv9860211115 #yiv9860211115ygrp-sponsor #yiv9860211115ygrp-lc #yiv9860211115hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9860211115 #yiv9860211115ygrp-sponsor #yiv9860211115ygrp-lc .yiv9860211115ad {margin-bottom:10px;padding:0 0;}#yiv9860211115 #yiv9860211115actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9860211115 #yiv9860211115activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9860211115 #yiv9860211115activity span {font-weight:700;}#yiv9860211115 #yiv9860211115activity span:first-child {text-transform:uppercase;}#yiv9860211115 #yiv9860211115activity span a {color:#5085b6;text-decoration:none;}#yiv9860211115 #yiv9860211115activity span span {color:#ff7900;}#yiv9860211115 #yiv9860211115activity span .yiv9860211115underline {text-decoration:underline;}#yiv9860211115 .yiv9860211115attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9860211115 .yiv9860211115attach div a {text-decoration:none;}#yiv9860211115 .yiv9860211115attach img {border:none;padding-right:5px;}#yiv9860211115 .yiv9860211115attach label {display:block;margin-bottom:5px;}#yiv9860211115 .yiv9860211115attach label a {text-decoration:none;}#yiv9860211115 blockquote {margin:0 0 0 4px;}#yiv9860211115 .yiv9860211115bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9860211115 .yiv9860211115bold a {text-decoration:none;}#yiv9860211115 dd.yiv9860211115last p a {font-family:Verdana;font-weight:700;}#yiv9860211115 dd.yiv9860211115last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9860211115 dd.yiv9860211115last p span.yiv9860211115yshortcuts {margin-right:0;}#yiv9860211115 div.yiv9860211115attach-table div div a {text-decoration:none;}#yiv9860211115 div.yiv9860211115attach-table {width:400px;}#yiv9860211115 div.yiv9860211115file-title a, #yiv9860211115 div.yiv9860211115file-title a:active, #yiv9860211115 div.yiv9860211115file-title a:hover, #yiv9860211115 div.yiv9860211115file-title a:visited {text-decoration:none;}#yiv9860211115 div.yiv9860211115photo-title a, #yiv9860211115 div.yiv9860211115photo-title a:active, #yiv9860211115 div.yiv9860211115photo-title a:hover, #yiv9860211115 div.yiv9860211115photo-title a:visited {text-decoration:none;}#yiv9860211115 div#yiv9860211115ygrp-mlmsg #yiv9860211115ygrp-msg p a span.yiv9860211115yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9860211115 .yiv9860211115green {color:#628c2a;}#yiv9860211115 .yiv9860211115MsoNormal {margin:0 0 0 0;}#yiv9860211115 o {font-size:0;}#yiv9860211115 #yiv9860211115photos div {float:left;width:72px;}#yiv9860211115 #yiv9860211115photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9860211115 #yiv9860211115photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9860211115 #yiv9860211115reco-category {font-size:77%;}#yiv9860211115 #yiv9860211115reco-desc {font-size:77%;}#yiv9860211115 .yiv9860211115replbq {margin:4px;}#yiv9860211115 #yiv9860211115ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9860211115 #yiv9860211115ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9860211115 #yiv9860211115ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9860211115 #yiv9860211115ygrp-mlmsg select, #yiv9860211115 input, #yiv9860211115 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9860211115 #yiv9860211115ygrp-mlmsg pre, #yiv9860211115 code {font:115% monospace;}#yiv9860211115 #yiv9860211115ygrp-mlmsg * {line-height:1.22em;}#yiv9860211115 #yiv9860211115ygrp-mlmsg #yiv9860211115logo {padding-bottom:10px;}#yiv9860211115 #yiv9860211115ygrp-msg p a {font-family:Verdana;}#yiv9860211115 #yiv9860211115ygrp-msg p#yiv9860211115attach-count span {color:#1E66AE;font-weight:700;}#yiv9860211115 #yiv9860211115ygrp-reco #yiv9860211115reco-head {color:#ff7900;font-weight:700;}#yiv9860211115 #yiv9860211115ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9860211115 #yiv9860211115ygrp-sponsor #yiv9860211115ov li a {font-size:130%;text-decoration:none;}#yiv9860211115 #yiv9860211115ygrp-sponsor #yiv9860211115ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9860211115 #yiv9860211115ygrp-sponsor #yiv9860211115ov ul {margin:0;padding:0 0 0 8px;}#yiv9860211115 #yiv9860211115ygrp-text {font-family:Georgia;}#yiv9860211115 #yiv9860211115ygrp-text p {margin:0 0 1em 0;}#yiv9860211115 #yiv9860211115ygrp-text tt {font-size:120%;}#yiv9860211115 #yiv9860211115ygrp-vital ul li:last-child {border-right:none !important;}#yiv9860211115