... have a string such as the following (column positions added for demo purposes):
String1.String2.String3.String4
1 5 10 15 20 25 30 -> length = 31
I'd like to end up with just the last ...
... SET @NewVal = '';
-- REDUCE THIS STRING TO THE SAME LENGTH AS SUBMITTED VALUE // not necessary for update
-- SET @NewVal = SUBSTRING(LTRIM(RTRIM(CAST(@NewVal ...
... data but the same length and the same type of data.
Why?
The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The ...
... -- Set variable default values
SET @NewVal = '';
SET @OrigLen = DATALENGTH(@OrigVal);
SET @CurrLen = @OrigLen;
SET @LoopCt = 1;
SET @DateVal = ''; -- ...
... and selecting this option will generate a c:\results_file.txt with the line numbers prefixed and open it; the 1000 is the number of lines but you can increase/decrease this to the length of the files you ...
Just putting a note as I have spent ages looking for a solution and getting it to work in my environment.
What?
Need to be able to omit HTML tags in certain fields of a mySQL database.
Why? ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.