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  

---

How many full-text indexes can a table have?

0 Answers  

---

What is a system database and what is a user database?

0 Answers  

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

What are the pre-defined functions in the sql server?

0 Answers  

---

---

What is the purpose of optimization?

0 Answers  

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

---

What do you understand by integration services in sql server?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---