Example 1:
select fornamn from Perstab where fornamn like 'rob%'

Result: 411 hits
Various names starting with 'rob'

Example 2:
select fornamn from Perstab where fornamn like 'robert%'

Result: 319 hits
Various names starting with 'robert'

Example 3:
select fornamn from Perstab where fornamn like 'v%'

Result: 3 hits
V.
V.
V(    )?

Example 4:
select fornamn from Perstab where fornamn like 've%'

Result: No records found

Example 5:
select fornamn from Perstab where fornamn like 'ver%'

Result: 17 hits
Vera (17 times)

Example 6:
select fornamn from Perstab where fornamn like 'vern%'

Result: 3 hits
Vern (3 times)

Example 7:
select fornamn from Perstab where fornamn like 'verner%'

Result: 33 hits
Verner (33 times)