If I have a field of type nvarchar(255), is it possible within a single select statement to split the value into two fields? For example of a given record:
dbo.image.filepath = 'e:\domain\repository\v000012.bmp'
Instead of simply saying "select filepath from image" to result in a single column containing that entire string, I would do something like:
"select [some code here??] as path, [some code here??] as filename from image"
where the result would be:
path = 'e:\domain\repository\'
filename = 'v000012.bmp'
I am trying to perform this split within the select statement that defines a view.