teradata - SQL Adding the same char into multiple fields -

-

i have sql query brings 17 numbers format

06037-11

i need add 0 before dash, is:

060370-11

is there easy way this? have seen stuff() option, don't understand it.

edit using teradata

previous response includes example teradata 14.x using regular expression support. following work in teradata 13.x or teradata 12.x without regular expression support:

select substring('06037-11' 1 (position('-' in '06037-11') -1))     || '0-'     || substring('06037-11' (position('-' in '06037-11') + 1))

Comments

Post a Comment

Popular posts from this blog

c++11 - Intel compiler and "cannot have an in-class initializer" when using constexpr -

-
the following test program compiles , runs fine g++. intel icpc (14.0.2) compile , run if use explicit type double instead of template. template version icpc produces error: icpc -g -o2 -i. -std=c++0x -c main.cc -o main.o main.cc(10): error: member of type "const t [9]" cannot have in-class initializer static constexpr t dx_[9] = { test code template<typename t> class myclass { public: static constexpr t dx_[9] = { 1.5, 2.0, -0.5, -0.5, 0.0, 0.5, 0.5, -2.0, -1.5 }; }; template<typename t> constexpr t myclass<t>::dx_[9]; int main(int argc, char *argv[]) { return 0; } // main why receiving error "cannot have in-class initializer" when using constexpr ? this bug of intel compiler, submitted intel , fixed in future versions. also see multiple constexpr bugs , sfinae bug intel c++ compiler 15 , method constexpr bug c++ compiler 15 on intel forums.
Read more

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp...
Read more

c# - Sort XmlNodeList with a specific Node value -

-
i searched web this, not able find related solution. i have following xml <table> <entity>employee</entity> <entityid>2786</entityid> <goal> <goalid>31931</goalid> <filterdata>lastmodifiedon¥2014-03-20t18:11:01.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> <goal> <goalid>31932</goalid> <filterdata>lastmodifiedon¥2014-03-22t15:26:09.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> <goal> <goalid>31932</goalid> <filterdata>lastmodifiedon¥2014-03-22t09:25:00.0000000+05:30Æactivetaskcount¥0</filterdata> </goal> </table> from above xml when read data got 2 separate datatables ; 1 employees , 1 related goals. what needed want sort goals related employee respect lastmodifiedon filterdata node. note: getting lastmodifiedon value split node value this ...
Read more