Regular Expressions _# at end of string

Question

I am using the REGEXP_LIKE function in Oracle 10g to find values in a column with a suffix of _#(like _1, _2 etc). I can find _# in any part of the value with the query below but can I return only values with _# at the end ? ``` SELECT * FROM Table WHERE REGEXP_LIKE (COLUMN,'_[[:digit:]]') ```

Accepted Answer

Sure. Use...

```
SELECT * FROM Table WHERE  REGEXP_LIKE (COLUMN,'_[[:digit:]]$')
```

The `$` character matches "the end of the string."

Regular Expressions _# at end of string

Solution

Problem