Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,277 members, 7,954,093 topics. Date: Friday, 20 September 2024 at 12:15 PM |
Nairaland Forum / Science/Technology / Programming / SQL STUFF Function Equivalent For Microsoft Access Database (1893 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)
How To Remember The Code You’re Learning / Digital Signature - An Image Utility Software / Facts About The First Female Programmer, Lady Ada Lovelace
(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. 4 |