And what about this:
SELECT no_id
FROM myTable
WHERE no_id LIKE '%a%'
Is there is a way to replace the a letter by a range 'a-z' (lower)?
Sorry to ask you again and thank you for your helpful help =:))
I can't just replace the lower characters by upper because exactly the sames records already exist in the database and are the good ones...
no_id id is the key of the table; For example, let's say 'MICHEL01' is a no_id in my table. I don't want to have two persons named 'MICHEL01' (because the...
My tables are that big... I have 3 tables of at least 1 million records each. And I just can't "replace" them because records will be duplicated... Records with upper case already exists and are the good ones!
I am new to oracle and I just don't figure out how I can do this, even with...
Hi!
I have a text field in a table and its name is no_id. An exemple of a no_id is: 'AB39MUO1'. An error occured and a user had entered the letters contained in the no_id in lower case (for example: 'ab39muo1').
I'd like to retrieve those records in the table but I don't know how to do this...
Hi,
I have a field date on a table. The format of the date is the following: "9/12/01 11:14:15 AM". The date stored on the filed is the current date. I'll like to update this field to the next day; I know I can do it by using the expression "SYSDATE + 1". I'll also like to...
Hi!
I have text boxs and an ole object on a report. Everything is OK on the preview report on the screen. This report is to be send by mail with the send option of the file menu. On the electronic version sent by mail, everything is OK for the text boxs but the OLE object is replaced with a...
I want to apply filter criteria in a report. I use a form to enter criteria and I use these criterias to sort report (in the filter propriety of the report). There are a lot of combo boxes and text boxes on the form and when I click the OK button of the builder, Access is telling me that...
I have a Text Box control on a form. The text box is multiple line (when the enter key is pressed, another line is generated) and is related (source) to a memo field on a table. All records doesn't have the same number of line entries. Entries are different and typed by the user (that is why a...
The action seems relatively easy, however...
I have an OLE object field stored in a table to show an image on a form (the image is associated with a record). I also drag the field on my form to create a bound object to be able to view the picture associated with the record. To insert an image...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.