Database

select P.Name, T.PhoneNumber
from TelPerson as P
inner join TelNumber as N
on N.PersonId = P.PersonId
where (@SearchName = '' or P.Name LIKE '%' + @SearchName + '%')
and (N.PhoneNumber = @SearchPhone or (
   @SearchPhone = '' and 
   N.PhoneNumber in (
      select min(PhoneNumber) from TelNumber where PersonId = P.PersonId)
   ))
order by P.Name, P.PersonId, T.PhoneNumber

SELECT 
    TelPersonId
FROM
    TelPerson
WHERE
    @criteria1 IS NOT NULL AND
    Investec LIKE '%' + @criteria1 + '%'
    
UNION
    
SELECT
    TelPersonId
FROM
    TelPerson
INNER JOIN 
    TelNumber 
    ON (TelPerson.TelPersonId = TelNumber.TelPersonId)
WHERE
    @criteria2 IS NOT NULL AND
    TelNumberText LIKE '%' + @criteria2 + '%'
    
GROUP BY TelPersonId

Vuyiswamb wrote:

here is the query but it gives me undesirable results.

Vuyiswamb wrote:

mybe you can explain in detail how the substring is working

Vuyiswamb wrote:

its true am normalasing the table, can you please tell me

SUBSTRING(Value, 1, 8) + ReplacementValue + SUBSTRING(Value, 11, 2)

Vuyiswamb wrote:

have you ever modify a large number of records by mistake?

Vuyiswamb wrote:

if yes what did you do?

Vuyiswamb wrote:

how did you feel after that?

simsem wrote:

the insert and delte of the adapter u must provide the paremeters manually.