₦airaland Forum

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.