i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

What is difference between index and primary key?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

What are clustered and non-clustered index?

0 Answers  

---

What are the encryption mechanisms in sql server?

0 Answers  

---

What are the properties of the transactions?

0 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

Can we perform backup restore operation on tempdb?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---