How to use Replicate in MS Access Database?

Question

In Sql Server for replication i use the following query

select replicate('0',5)

it gives result as

what is the equivalent for this in MS Access

score 2 · Accepted Answer · answered Oct 09 '13 at 06:36

2

try STRING()

SELECT String(5, '0')

answered Oct 09 '13 at 06:36

John Woo

1 Answers1