| |
select *
from #dbPrefix#.tblTenant
where
left(company, 1) >= '0' and
left(company, 1) <= '9'
ucase(left(company,1)) = '#url.letter#'
LIST OF TENANTS & EXHIBITORS
|
|
#
#Chr(charid)#
|
|
#Company# #Website#
|
|
Suite: #Suite#
|
Show Room Phone: #ShowRoomPhone#
|
|
#Email#
|
|
No tenant has a name starting with #url.letter#.
|
| |
|
|
|