Basic SQL help

[da_mic_1530]

Hey all, just need a point in the right direction on a few bits and bobs

in SQL

Using a field value in a query

I have a statement that replaces anything with a blank entry on 1 field and replaces it with EMPTY (This is hardcoded)

I wish to rather than hard code this, to feed the value from a field in test_table

i.e nvl(randomfield = 'I want my value from test_table here')

Secondly

Inserting query records into a table

I would like a bit of help inserting records into a table from a query

e.g

select surname,
a_hard_coded_value (e.g query number 1)
from test_table
into another_test_table (column1, column2)

Finally Identifing White Space
I wish to check the a certain column's field values do not have whitespace

e.g 'value' - is fine
but 'value ' -is flagged

 

[da_mic_1530]

Many thanks, especially on the whitespace, I did a bit of reading today and fixed everything bar the whitespace. So that will prove useful tomorrow.

Again Thanks So Much for a helpful reply

 

[da_mic_1530]

edit - being a numpty!

Thanks again the 2nd whitespace query was the initial request I was after