Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,154,520 members, 7,823,232 topics. Date: Friday, 10 May 2024 at 07:16 AM |
Nairaland Forum / Science/Technology / Programming / SQL STUFF Function Equivalent For Microsoft Access Database (1848 Views)
I Wanna Learn Coding And Microsoft Access In Ibadan.. / Is Microsoft Access Still Relevant Today? / Help Him Create Interdependent Fields Microsoft Access (2) (3) (4)
(1) (Reply)
SQL STUFF Function Equivalent For Microsoft Access Database by skoten(m): 1:27pm On Jul 30, 2015 |
Hi guys,please I need someone to assist me on SQL STUFF function equivalent for Microsoft Access Database For example; I have this number 1234567890 and i want to write a query that will update it to the 123/4/5/67890. The following STUFF function will do that. DECLARE @Acct_No nvarchar(100),@Acct_No nvarchar(50) set @Acct_No = '1234567890' select STUFF (STUFF(STUFF(@Acct_No, 4, 0, '/'), 6,0, '/'), 8,0, '/') Thanks guys! But this STUFF function doesn't work or update for Microsoft Access Database....i tried using REPLACE (but this won't work) Please someone should help with Microsoft Access Database equivalent. |
(1) (Reply)
Learn Basic Concept Of Coding And Quickly Adopt Any Language Of Your Choice / How To Resolve Identity Verification Failed 3 Times On Google Adsense Account / Creating A Future For Nigerian Programmers
(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. 7 |