Geoffseymour.Com

December 31, 1969

Extract file name extension from file path using T-SQL

Filed under: 292 — admin @ 6:00 pm

HTTPRequestURIStem is the column contains file path, e.g. /webpage/default.aspx

SQL [Show Plain Code]:
  1. REVERSE(SUBSTRING(REVERSE(REVERSE(SUBSTRING(REVERSE(HTTPRequestURIStem),0,
  2. CHARINDEX(‘/’,REVERSE(HTTPRequestURIStem))))),0,
  3. CHARINDEX(‘.’,REVERSE(REVERSE(SUBSTRING(REVERSE(HTTPRequestURIStem),0,
  4. CHARINDEX(‘/’,REVERSE(HTTPRequestURIStem))))))))

This function will return “aspx” for “/webpage/default.aspx”.

NOTICE: I put the code in seperate lines for readablity.

Source: chenty

Powered by WordPress