Fulltext Search Over Data With Underscore

I have a indexed table where one of the indexed columns can contains data with an underscore. ID Name 1 01_A3L 2 02_A3L 3 03_A3L 4 05_A3L 5 some name 6 another name 7

Solution 1:

Kees C Bakker is 100% correct, but if you just wanted to get the results you require without all of the steps. The quick/dirty way to do so would be change your search to be a like...
Select * from MyAmazingTable where Name like '%A3L'
The % in this case would represent whatever comes before and make sure the last 3 characters are A3L. Which will give you the results that you are looking for.