How do i found customer details based on costomer name
971085Oct 29 2012 — edited Oct 30 2012Hi All
i have a table called 'customer'
it contains columns like "customer name" and "customer ID" "customer Introducer Name" "customer introducer ID"
and it is having more than 4lac records
now
if i give input as "introducer name" or" Intoducer Id "
output will be
how many customers introduced by him
ex: customer introducer name like Shashi Bhushan Singh
if i give shashi it will serch for all customer introducer names like shashi
and if give bhushan it will serch for bhushan and
if i give singh it will all the customers introduced by singh
same for customer id alsio
customer introducer id is like "2129908"
if i give input customer introducer id like "2129908" output should be how many customers intoduced by this customer introduced id
Edited by: 968082 on Oct 29, 2012 10:30 AM