SQLite strings filtering

for example my "select" query returns rows:

• "asd/1"
• "asd/2"

but for me rows "asd/1", "asd/2" represents the same value. Is any way to truncate strings to such result: (i want to truncate everything after '/' inclusive)

• "asd"

??