Hi,
i have cereated a table and inserted into values for carddetails.
e.g. cardnumber=1234567891234567
now i have a problem here is
when i enter only 6 digits from the above cardnumber i have to retrieve the data
So, are you looking for the query statement to get this info...
And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'
NOTE: replace <table_name> with the name of your table.
You might have to modify the statement depending upon how your calling it.
Check out more info at http://www.w3schools.com/sql/sql_where.asp
Hope this helps.
101 views
Usually answered in minutes!
thanks for trying
but i didn't get the correct answer
from the above post i have to retrieve the data by entering the first 6 digits only
so please help me for this query
it's very urgent for me
×