Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,343 members, 7,957,914 topics. Date: Wednesday, 25 September 2024 at 12:57 AM |
Nairaland Forum / Science/Technology / Programming / Convert Jet-sql To T-sql (1497 Views)
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)
(1) (Reply)
Convert Jet-sql To T-sql by Sollyk(f): 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 |
(1) (Reply)
YOUR OPINIONS ARE NEEDED: What Is The Future Of Nigerian Software Industry / Update Statement Problem In Vb.net / A 16 Year Old Nigerian Built A Photo-sharing App... Check It Out!
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 6 |