Convert Jet-sql To T-sql - Programming - Nairaland
Nairaland Forum › Science/Technology › Programming › Convert Jet-sql To T-sql (1567 Views)
1 Reply
| Convert Jet-sql To T-sql by Sollyk(op): 5:38am On Sep 08, 2011 |
Please can someone help me to convert this JET-SQL to T-SQL SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Student Name], Students.* FROM Students ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])); Please u can mail me d solution @ sollyk4u4real@yahoo.com Thanks |
How To Convert Folder/file To Jpeg Format • Convert Code From Php To Vb.net • Help me convert this Vb6.0 code To Vb.net • 2 • 3 • 4
Buy A Top Level .com Domain Name, Ssl Support And Host For N5,000 (per Year) • Hello Python Programmers Check My Small Projects • Software Engineers Needed