Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2010-10-11 : 17:22:44
|
| Is it possible, to get filename if any in the path or 'None' as resultset.Query: select filename from tab_recipients where mod_recID=@ModIDEXAMPLE: If filename has the following path with the filename:D:\ProjectFiles\MYAPP\RM\209.558-Vacation_Request.pdfget the filename=209.558-Vacation_Request.pdfif the filename just hast the path with no filename at end:D:\EFiles\CCS\RM\PACOTECH\OPS\Recordsthen filename has to be 'None'Thank you very much for the helpful info. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Select query get filename fro m path if any