2. ASPRunnerPro General questions
  3. select issue
This topic is locked

select issue

 		2/12/2015 10:24:04 AM
ASPRunnerPro General questions
N
 netgrass author

Dear all,
can someone help me to fix a sql selec question,
example:
id bank code

1 A_bank 111

2 B_bank 222

3 B1_bank 333

4 C_bank 444

5 C1_Bank 555
how can i quarry one or more bank_name to get the result as below
search result:

3 B1_bank 333

4 C_bank 444
Thanks

Net//
mperry622 2/12/2015
Select id, bank, code from [database] where code="333" or code="444"


What are you exactly trying to query? I can give ya some help I just need more details..
But I will help.
mperry622 2/12/2015

Select id + ' ' + bank + ' ' + code from [database]
this will print out . id bank code

with spaces between.