I have a query to retrieve all the files which needs to be navigate through the predefined folder and filename need to be of certain format,
Like example:
`V<XXXXX>.doc` or `<XXXXXX>.doc`

Where file name is varchar, but is the numbers from 0 to 9
 (the exact pattern of file name would be V012134.doc or 3213424.doc)

```
select filename from table1 where filename LIKE '%<> %'

```

Can you please suggest.

Thanks,