I am new to SQL so please bear with me,
I have a table called PB_Code_Date which contains the following fields amongst others;
FDP P2321234 Null
Is it possible to create a stored procedure which can find the "P" preceding the numerical numbers in the column PB_Code and put that value into a column called Orig_PB_Code but only if the column Orig_PB_Code has a value of null?
so the result would look like
FDP P2321234 P2321234
Many thanks in advanced.