concatenation and selecting alpha range in SQL
Posted on 2004-04-05
I am programming in visual basic and am having trouble with a couple of queries. They must work against access and oracle. The problem is, as I am working off site I only have access and do not know if what I am doing will work against oracle as well.
Problem 1 - concatenation.
I need to select from 2 separate db fields and concatenate them as one field in the query results. So I want surname and initials to be selected as name.
This works in Access:
select [surnamefield] + ' ' + [initialsfield] as name from....
will this work in oracle as well ?
Problem 2 - select alpha range.
The customer's office is split by surname of their customers. So miss smith deals with all customers whose surname is in range beginning A to BL. If she needs to print all pertinent items for that day for her whole alpha range the sql to do this in access is:
select * from [table] where [surnamefield] >= 'A%' and [surnamefield] <= 'BL%'
again would this work in oracle ?
thanks for your help