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 dynamic cursor in SQL SERVER?

0 Answers  

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

What is data compression? : sql server database administration

0 Answers  

---

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

What is the use of stored procedure?

0 Answers  

---

What is oltp (online transaction processing)?

0 Answers  

---

How do you delete a trigger?

0 Answers  

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---