Input string in web form: laproom01
The select SQL below return nothing:
select * from Device where FREETEXT(DeviceNo,'laproom01')
How to create select sql by pass all special characters in database, return 3 rows below:
The expected output:
ID DeviceNo
1 Lap.room-01
2 Lap.room.01
3 Lap-room-01