Indresh says:
Hi jerryhien,
Please provide complete details of your requirement. How can we distinguish the insertion of special character? Is there any specific index where you want to insert the special character?
I have a table (table name is Device with 2 column: ID and DeviceNo, the DeviceNo have some special character as: . _ - ):
-------------------------------------------------------------------
ID DeviceNo
1 Lap.room-01
2 Lap-room-02
3 Lap_room-03
4 Lap_Sell-01
5 Lap.Sell-02
6 Printer.Public-01
7 Printer-Public-02
---------------------------------------------------------------------
I have a search textbox in webform for search Device by the DeviceNo.
I would like when user input into search textbox: laproom
The sql query command will return the Device: Lap.room, lap-room, Lap_room . user don't need type (the character: . - _ ) between the 'lap' and 'room'
The Expected sql result is:
ID DeviceNo
1 Lap.room-01
2 Lap-room-02
3 Lap_room-03