var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql function help
i have a table with varchar2 data time column which have values in below form
(123, 445, 564) or (445,123,564)
i want to capture only 123 part from above values in one sql statement and for this kindly guide me how to achieve this?
There is no varchar2 data type in SQL Server.
In your example, are those two rows or one? Are the parentheses part of the data?
What do you mean by "capture"?
these two type of values are in same column and without parenthesis. capture mean get, I want to get specific string which i mentioned earlier.
Well this satisfies the request, but I don't think it is really what you mean:
DECLARE @text_to_capture AS VARCHAR/*2*/ = '123'
SELECT captured = @text_to_capture
WHERE varchar2_column LIKE '%' + @text_to_capture + '%'
BTW - are you familiar with first normal form? Because you should not be storing your data like that.