Convert Jet-sql To T-sql - Programming - Nairaland
Nairaland Forum › Science/Technology › Programming › Convert Jet-sql To T-sql (1554 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
Please Help! How Do I Open My Visual Basic Program In Visual Studio 2008? • When You Get Error When Compiling Your Project How Do You Feel • I Am In Need Of A Programmer To Partner With As A Co-founder L