1

I need to build up a dynamic path from inside an SQL script. It started with something like

select left(
    db_property('File'), charindex (
        DB_PROPERTY ( 'Name' ), db_property('File')
    ) - 1
)

but need to add a subfolder there. For the subfolder, from my understanding, I would need to have the path delimiter so it can run under Windows as well as unixoid systems (and who knows if there will be some other systems somewhere maybe using ? as delimiter ;))

I've checked the db-properties but didn't found anything fitting. Is there a good way to determine the delimiter?

frlan
  • 495
  • 1
  • 4
  • 26

0 Answers0